We are running Oracle RDBMS V6.0.36.3.2 on a Sun with SunOS Release 4.1.3.
In an Oracle 7 manual I found references to 'fold_after' and 'fold_before'. I
thought I would try them with the version of Oracle we have. Surprise!
They worked!
Here is a script without 'fold_after' to print an address:
set heading off;
select rpad('John Q. Public', 80) Name,
rpad('1 East Main Street', 80) Addr1,
rpad('Anytown, UT 90102', 80) Addr2
from dual
/
Here is the same script with 'fold_after':
set heading off;
column Name fold_after 1;
column Addr1 fold_after 1;
select 'John Q. Public' Name,
'1 East Main Street' Addr1,
'Anytown, UT 90102' Addr2
from dual
/
The output of both, when spooled to a file, are identical:
John Q. Public
1 East Main Street
Anytown, UT 90102
Now the questions:
- Does Oracle support 'fold_after' and 'fold_before' in Ver. 6?
- Besides the fact that the sql statements read easier, what are the
other benefits of 'fold_after' and 'fold_before'?
