Monday, May 21, 2012

Getting custom linear unique id in oracle in select statement based on Date

I have an oracle table such as this.



enter image description here



I want to get a custom unique id in the format Mon-YY/unique number in the select statement



The result would look like(see the column UNIQUEORDERID)



enter image description here



Is it possible to achieve the result in select statement?
Please help me write the query.



Thanks,
Sajad





No comments:

Post a Comment