Skip to Main Content

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 the column length in an sql query

GaillimhApr 28 2011 — edited Apr 28 2011
Hi,
Is there a way to set the column length in a query without using sqlplus commands like row size and format column.

I'd like to do it just from the sql query itself.

select 'this is a test' from dual; Can I define the width of this column in the select statement



Cheers.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 26 2011
Added on Apr 28 2011
4 comments
1,734 views