to_number (systimestamp)
Neo-bFeb 20 2013 — edited Feb 20 2013Hello All,
I am trying to insert an order unique number any time I select from my database.
I did the below query
select to_number(to_char(systimestamp,'yymmddhh24missFF')) from dual;
It is returning a number in format 1.3022E+17.
My question is it only a display ? and the number will be stored in teh database as full number?
So in case I inserted these records to a table and I order this table by this number, will be ordered correctly ?
when I " set numwidth 30" it was correctly displayed, my question is it only an issue of display ?or storage wise in the table?
Is it a good way to sort my records in the table instead of using a sequence?
Regards,