Does the oracle order by clause preserve the sequence of the duplicate items
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