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!

select column at a specific position

venkatesh867Jun 14 2016 — edited Jun 16 2016

Hi,

     My select query is a dynamic query.

     My requirement is to select the last column in a first place.

Ex:

select column1,column2,column3 from table_name;

I need

select column3,column1,column2 from table_name;

Since the query is a dynamic one i have to select the last column in a first place after the query gets dynamically formed.

Thanks in Advance.

Regards,

Venkat

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2016
Added on Jun 14 2016
10 comments
2,587 views