I'm doing a number of queries that return a result string. These strings are placed in a text file and then emailed via a PowerBasic exe. The queries retrun multiple "records", each within a RESULT_STRING that is placed in an array.
A simple example of the result strings piece of the query would look like:
B.PRODUCT_NAME || '* (#'||TO_CHAR(A.PRODUCT_ID) ||')' AS RESULT_STRING
The width of the product name varies and the max length is unknown at the time.
I would like to format the string within the SQL if possible so that it would be set up in columns. The result would look like:
Is this possible within SQL ?
My other alternative is to handle it within the calling program, but I was hoping I could do it in the query.