Skip to Main Content
Forums

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!

use of order by in insert statement

Sachin TOct 15 2009 — edited Oct 15 2009
Hi friends,

I am working on a system where i have observed that it is using order by clause in insert statement for GTT.

eg.

insert into t_gtt values select a,b,c from t1 order by a;

What i know is that records are not fetched in order by which they are inserted.

What is use of order by in insert.

Could you please help me
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 12 2009
Added on Oct 15 2009
7 comments
1,396 views