gopi6417 (2/25/2015)
I don't know exactly.Could you please tell the syntax on Oracle.
The poster realised after posting the original question that they were in the wrong forum.
So if you are providing a SQL Server solution, it is unlikely to help the poster. Might help other people in the future, of course.