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!

"column xxx format a30" clause includable in SELECT statement?

pstein-JavaNetJun 3 2008 — edited Jun 4 2008
Usually I can preformat the width of a column by entering a command like

column name format a30

before the actual SELECT statement

SELECT .... name FROM blah;

However I could imagine that I can somehow include the format clause into the SELECT statement itself similar to

SELECT .... name formatcolumn=A30 FROM blah;

Is this possible somehow?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2008
Added on Jun 3 2008
6 comments
786 views