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.