var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to return truncated data?
Not sure if i titled it correctly but here is basically what I am trying to do:
The statement below returns the behaves as follows:
As you can see from the code above, both are linked by the "INSTANCEID" Column.
SELECT c.DATA CUSTOMER, r.DATA ID_CODE FROM CUSTNAME_TABLE c, ID_TABLE r
WHERE (c.INSTANCEID = r.INSTANCEID) ORDER BY CUSTOMER
But what I would like to do is create a statement that will return the data above as follows:
thanks in advance,
There are several techniques; check this page which talks about string aggregation. Also, you might visit Ask Tom site and see what Tom Kyte said about it.
If you decide to search by yourself, "STRAGG" might be the keyword you need.