Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> sqlplus...automatically setting a column width?
I have some really wide varchar columns, but the data
is not very long. Is there a way to automatically
combine these two statements, to set the column width
to the width of the longest string?
SQL> select max(length(x2)) from foo;
MAX(LENGTH(X2))
32
SQL> column x2 format a32
Many TIA!
Mark
-- Mark Harrison Pixar Animation StudiosReceived on Fri Jun 30 2006 - 01:02:10 CDT
![]() |
![]() |