Hi Sreejith,
even if there would be a particular way in which the rows with the same value for your order by column are returned I wouldn't rely on it.
The order could change with changing data,new indexes, new Oracle versions, etc. and will simply be not guaranteed.
As far as I know this depends on some things, e.g. if an ordered index was used for this sort (maybe you've an ordered index on column A and B and you use Order By A, then (if the Optimizer decides to use the index) the result for rows with the same value for A will be sorted by B.
If no Index is used I think you will retrieve the rows in physical order in the tablespace. This means in no guaranteed order at all.
You can try this e.g. this way: insert a lot of rows in some
testing table. Then perform your query. Delete a block of rows from the "middle" of your table, then insert new rows and perform your query again.
But as I said some times before: never rely on any order which you don't explicitly define in your order by clause. Because "results may vary"...
John