Oracle Alert - Column Alignment
Hello all,
I'm trying to create a simple alert with several columns, but the data is not aligned.
I tried to concatenate the columns into one column and ran the SQL, and with "Oracle SQL Developer" it's aligned perfectly:
SELECT (RPAD(msib.segment1,25,' ')) || RPAD(msib.description,45,' ') || RPAD(ol.request_date,15,' ') ||
RPAD(oh.order_number,15,' ') || RPAD(loc.customer_name,40,' ')
But, when I put it into an Alert - the data is not aligned (sorry for erasing the data):
Any idea how this can be solved?
Thanks,
Tom.