I have the following table
CREATE MULTISET TABLE HASH_V ,FALLBACK (
PRIMARY INDEX ( hashVal );
--data inserted in this order
insert into HASH_V values (1);
insert into HASH_V values (5);
insert into HASH_V values (8);
insert into HASH_V values (3);
insert into HASH_V values (4);
insert into HASH_V values (7);
insert into HASH_V values (0);
insert into HASH_V values (10);
Get output in this sequence...
--I wanted a sequence value against it hence I tried
Thanks. I thought so. There was a rowid column that is no longer available. Can someone help me understand why? Is it to do with mpp architecture?
SQL SELECT does NOT guarantee (even in Oracle) any order of the rows returned if no ORDER BY clause is used.
The Oracle ROWID does not provide an order of insertion. It is related to where the row is stored (datablock, row inside the datablock, datafile). It is not immutable and can be reused if you delete a row and insert a new one.