PL/SQL (MOSC)

MOSC Banner

Does the oracle order by clause preserve the sequence of the duplicate items

edited Sep 28, 2009 4:43AM in PL/SQL (MOSC) 11 commentsAnswered ✓
 Hi,

create my_table (id number primary key, name varchar2(80))

/

insert into my_table(1,'smith');

insert into my_table(2,'leon');

insert into my_table(3, 'leon');

Now assuming I issue the following sql:

select * from my_table order by name;

My question is: the sequence of row 2 and row 3 is fixed or not whenever I issued the same query?

Thank you very much

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center