I have an oracle table such as this.
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)
Is it possible to achieve the result in select statement?
Please help me write the query.
Thanks,
Sajad
No comments:
Post a Comment