Skip to Main Content

SQL Developer

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!

Show Column number in Query Result

751246May 4 2011 — edited May 5 2011
In SQL Developer, it would be very useful to see the actual column number in the Query Result window. For example - when developing views with UNIONS, it is very easy to have a different number of columns in one union. Beng able to immediately see what number column a particular output column is would make it much easier to debug the view. At the moment, you have to manually count the number of columns in the output, and some of my views often have 40 or 50 columns in them.

Also useful if you want to quickly put in a couple of ORDER BY x,x,x commands to check the output data.

Edited by: user10777687 on 04-May-2011 02:26

Edited by: user10777687 on 04-May-2011 02:26
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2011
Added on May 4 2011
3 comments
1,917 views