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!

Column Formatting in SQL PLUS

235699Sep 11 2003 — edited Sep 12 2003

When I issue a query on all_ind_columns
for 3 columns table_name, column_name and index_name
I get the output as below
ie. I dont get them on one line
I believe it is because Column_name is Varchar2(4000)
How do I get all the columns on same line .

Thanks
Ashwin N.

TABLE_NAME
------------------------------------
COLUMN_NAME
------------------------------------
INDEX_NAME
---------------------------------

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 10 2003

Added on Sep 11 2003

4 comments

522 views