Listing data in 1 line only (no wrap)
488972Oct 10 2007 — edited Oct 10 2007In SQLPLUS, I am running the following select, to generate index ddl statements:
select dbms_metadata.get_ddl(segment_type,segment_name,owner),';'
from dba_segments
where tablespace_name = 'ADMIN_MEDIUMIDX'
and segment_type != 'INDEX';
When I spool this, the lines for each ddl wraps, and my ddl's are split up into multiple lines. How can I run this, so that it generates only 1 line for each ddl ?
Dirk