var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Displaying data using SQL - 10g
I was wondering if someone could tell me if it is possible to display 2 headers for a column?
How do I specify the XYZ part of the header I want to show underneath ABC?
SELECT A+B ABC
SQL> column my_col heading 'my|col'
SQL> select 1 my_col from dual;
Thanks Pablolee. But I don't want to break a column and display it on 2 lines. I want to add a word to the column and display the column name and the new word on 2 lines.
I got around this by making the new word part of the column name and using your advice and that did the trick, however, the word displayed at the bottom was right-justified.
Any ideas how I could bring XYZ to the centre?
Last edited by shajju; 10-07-13 at
How does that differ from displaying a column header on two different lines? You'll need to be much clearer with your requirements.
You're right Pablolee.
I got it in the centre by padding it with spaces on the right Thanks.
Good stuff. Glad you got it sorted
Just one small request.
Is there any other way to do this? Actually my app doesn't accept the
as a valid SQL query?
Well, since you haven't told us what 'your app' is, it's kinda hard to say anything about this. I could potentially give you 30 responses, none of which would be valid in your app.