Will data be retrieved from a table in Oracle in the same order that it was inserted?I have a situation where I have a table with a column "AccountType".Now this field has values like "New","Amend","Closed" etc.How can I ensure that when records are being retrieved from this table,the record with an "AccountType" value of "New" is the first row followed by the one with "Amend" etc.I know that using "Order By" in the SQL query is the way to go but I am not sure as to how it will work on Strings.Also please note that there is no other field available in the table - like a date field that may be used for Sorting.
Like Jan said, there's no guarantee that a SELECT statement without an ORDER BY will return the rows in any particular order. This holds true no matter what database vendor you are using. I think that your best bet would be to add a column that records the time at which the row was added. Or, if the table uses a unique number for its key, you might be able to get away with just sorting by this number.