Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Set Column width in query (not using SQL*Plus)

812493Nov 10 2010 — edited Nov 10 2010
How can I Set Column width in query

I understand you can set column width using
column col1 FORMAT A5
select col1 from table1;
But this only works in SQL*Plus

I want to be able to do this in a regular SQL query window (not in SQL*Plus), how can I do it.....

I am using a 'SQL window' in PL/SQL Developer IDE

and when I use this syntax it says:

ORA-00900: Invalid SQL statement

Any suggestions are appreciated...

thanks,
M.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 8 2010
Added on Nov 10 2010
#column
4 comments
3,933 views