The only method I know of is to concatenate the fields together in one column. If there is a way to have variable sized SQL*Plus column formatting, I'd love to see it...seriously...it would be cool.
Until then... 1 select substr(ename,1,length(rtrim(ename))), job 2* from emp SQL> / SMITH |CLERK ALLEN |SALESMAN WARD |SALESMAN JONES |MANAGER MARTIN |SALESMAN SQL> edit Wrote file afiedt.buf 1 select substr(ename,1,length(rtrim(ename)))||'|'||job 2* from emp SQL> / SMITH|CLERK ALLEN|SALESMAN WARD|SALESMAN JONES|MANAGER MARTIN|SALESMAN -----Original Message----- Sent: Thursday, September 19, 2002 8:51 AM To: Fink, Dan; [EMAIL PROTECTED] I don't want just 4. It's variable length and I want the actual number of valid bytes. Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
