Re: 'Carriage Return' in spool file

Youu can also control the carriage from the SELECT statement, by using CHR(10). For example, if you were writing dynamic sql you would write like this:

(This is a poor example because the select is so short, but just assume you wanted output on two lines:)

Desired result for all tables:

    select count(*)
    from TABLE;

The Select:

    Select 'Select count(*)' || chr(10) || ' from ' ||     TNAME || ';'
    from TAB
    Where TABTYPE='TABLE';

You might still need trimspool to get rid of whitespace, but you could control your text with this method.

Robert Proffitt
Beckman Coulter
RTProffittNOSPAM_at_Beckman.com

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 30 1999 - 18:24:56 CEST