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!

sqlplus auto-format columns ?

2654204Aug 14 2014 — edited Sep 3 2014

Hello fellows,

I have a situation here, and maybe some of you could help.

I am using sqlplus, and a user asked to execute a "select *" query and send the output.

The problem is that the table has many columns, and the resultset was unformatted, i tried to format all the columns, but i couldn't solve it. The better thing that i've got was doing 'set markup html on', and give the output in xls.

Do you guys know another way to solve this issue ?

Thanks.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2014
Added on Aug 14 2014
12 comments
8,417 views