murarka.ankita2007 (3/25/2012)
please convert below code of sql server to sql plusso that it doesnt generate syntax error.
Please don't take this the wrong way but this is so wrong it is hard to find where to start.
SQLplus is not a language, is an interface to run SQL commands... which do not allow to create a stored procedure.
To create a stored procedure you should use PL/SQL syntax... which is not the same syntax you use when running SQL command on SQLplus.
As a rule of thumbs, to stay out of troubles and avoid hanging yourself from a bridge you may want to think that anything more complex than "select * from table" has to be re-written from scratch. This requires that the person doing the job understands both Transac-SQL and PL/SQL; then the person should understand what the code is doing in one language and re-write it on the other one.
Hope this helps.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.