We help IT Professionals succeed at work.

Sorting Column names while viewing data in TOAD

cstraim
cstraim asked
on
2,323 Views
Last Modified: 2013-12-12
I have a dataset with over 256 columns (probably like 500).  I would like to be able to sort the colmn names in alphabetical order when looking at the data view.

Can Sql order the column names AND show the data contained within the columns?  

Note:  Im not trying to sort the data itself, just the column or "field" names

I'm using Toad
Comment
Watch Question

Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
You may take a look at the Schema, however modifying this can break referential integrity rules.
Naveen KumarProduction Manager / Application Support Manager
CERTIFIED EXPERT

Commented:
go to schema browser, click on the table u want to view and then click on columns tab where it shows all the columns present in that table, ( by default i think columns are ordered by column id but not sure ) - so just click on the column_name header in the columns tab to sort the column names in ascending or descending order and then do a multi select and copy all the column names and paste it in the below.

select
<<paste it here>> -- remove the last comma after the last column name,
                               -- the column names will be in   order of column names as u wanted
from your_table;

Thanks
Forced accept.

Computer101
EE Admin
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.