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!

Columns in SQL Worksheet do not come in the right order

419978Feb 17 2006 — edited Feb 23 2006
This is the steps I followed in SQL Worksheet :

Execute SELECT STREET1, A.* FROM ADDRESS A
Move the column STREET1 in the Results to be the third column
Execute once again Execute SELECT STREET1, A.* FROM ADDRESS A
STREET1 will always come as the third column even if the STREET1 column is the first column in the select statement
Modify the scripts and run it SELECT STREET1, STREET2, A.* FROM ADDRESS A
Re-Execute SELECT STREET1, A.* FROM ADDRESS A
The STREET1 column is still the third column
Run any other query, but if I run the first query, the column will always be the third column.
I deleted a space before A. and re-ran it. STREET1 is now the first column
I added a space before A. and re-ran it. STREET1 is now back as a third column

Is this an expected behaviour, or is it a bug ?

Environment :Windows XP & SQL Developer V 1.0.0.11.84 Build MAIN-11.84

-Nags
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 23 2006
Added on Feb 17 2006
12 comments
713 views