Convert Stored Procedure from SQL Server to Oracle (Filter builder)

In Progress Posted Jan 29, 2016 Paid on delivery
In Progress Paid on delivery

Hi. I have a stored procedure in SQL Server (there is a function as well) that needs to be converted to Oracle version 11g. The SQL Server version is designed to be used with dynamic sql in SQL Server. The Oracle version needs to be run in dynamic sql in Oracle. So the output will be slightly different.

Please test against any simple table you may have loaded in oracle. To test, please also compare the output of the SQL Server version to the Oracle version. Oracle requires a different SQL syntax so I know it won't match exactly. Please test with different inputs and orders to be sure you have it correct.

Overall, the SQL Server version didn't take me very long and so i hope the oracle version is not too complex. I do have some additional documentation in the stored procedure.

Thank you.

-- note that the stored procedure and function are attached to this project. I am not sure if they were attached the first time. I will add again.

I have the file attached now. it was originally not allowing .sql as a prefix. The sql server stored procedure and function are there.

Microsoft SQL Server Oracle SQL

Project ID: #9514286

About the project

6 proposals Remote project Active Jan 30, 2016

Awarded to:

vinaysinghh

I am oracle dba having more the 6 yrs of experience ...........i can do this task easily ...........................................................................................

$111 USD in 3 days
(43 Reviews)
5.0

6 freelancers are bidding on average $173 for this job

scorpioangry55

You can contact with me at any moment to discuss your task. You can contact with me at any moment to discuss your task.

$200 USD in 3 days
(10 Reviews)
4.6
narendragautam

Hi, I am interested. give me scripts of your sql stored procedure for conversion to oracle thanks NArendra

$200 USD in 3 days
(1 Review)
2.3
webprog4hire

MCSA SQL 2012 Microsoft Certified Solution Associate. work alone and looking for work HI i am expert in .net and sq and ready to start work now currenty working for a usa client prefer to work in client time More

$216 USD in 1 day
(2 Reviews)
1.6