Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Listing data in 1 line only (no wrap)

488972Oct 10 2007 — edited Oct 10 2007
In 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 7 2007
Added on Oct 10 2007
12 comments
3,381 views