Someone knows or knows an easy way to migrate stored procedures from SQL Server to Oracle.
Someone knows or knows an easy way to migrate stored procedures from SQL Server to Oracle.
Has, knowing well how each bank works :)
This is undoubtedly the best way to have one or two professionals who understand well, especially if the procedure uses very specific resources such as hints .
But to help, there is this site that converts most of the basic syntax of many databases online, not only oracle
and sql-server
: link
I suggest putting the query there that will help a lot, leaving it functional, there you focus on the very specific things. To help you, you have this great material comparing the two databases, in English: ss oracle compared