I need to append the date to a unique number for each insert according to the date at which the data is being insert.
Is there a way to convert sysdate to say 05112007? The nearest i can get is '05/11/2007' by using
select to_date(sysdate,'dd-mm-yyy') from dual
In any case, is there such a thing called a date sequence?