Convert Stored Proc/Function from SQL Server to Oracle

Cancelled Posted Feb 1, 2016 Paid on delivery
Cancelled 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 SQL Server stored procedure that is attached.

Thank you.

Microsoft SQL Server Oracle SQL

Project ID: #9531283

About the project

22 proposals Remote project Active Feb 2, 2016

22 freelancers are bidding on average $150 for this job

coderPros

I've been developing web and software solutions for well over a decade & have always worked heavily of the database side of things. I have extensive experience with SQL Server, MySql, Oracle, and Postgres. I had a look More

$175 USD in 3 days
(18 Reviews)
5.3
scorpioangry55

I'm certified Oracle DBA and developer since 2000. You can contact with me at any moment to discuss your task.

$250 USD in 3 days
(10 Reviews)
4.6
ref2

Hi I have 15+ years of experience in developing applications on oracle database. I have bachelor degree in cs, 25 oracle certified trainings and web app dev certificate from University in Chicago. I developed many pl More

$111 USD in 3 days
(26 Reviews)
4.7
acronymsolutions

Hi, I am 16+ years experienced Database Programmer at CMMI-5 level company. I am working on : RDBMS: Oracle,MySQL,MSSQL Server 7.0/2000/2008R2 and Onwards. Data Base Tools : Database Configuration Assistant More

$155 USD in 3 days
(32 Reviews)
5.7
jlsproject

Hello, my name is Denis. I have more than 10 years of Oracle experience. I can help you. Besat regards, Denis.

$45 USD in 3 days
(22 Reviews)
4.4
Baraiya

Hello Friend, i am Software and Database Developer My good points: - Master Degree in Computer Science - 4+ years of experience - Professional developer - Delivered before time - My good habit is to leaving com More

$170 USD in 3 days
(26 Reviews)
4.3
khannanav

We have a team of expert DB Architects and DB developers with more than 10 years of rich industry experience & would be more than happy to work on the project. We have expertise in designing DB schema from scratch,w More

$211 USD in 3 days
(8 Reviews)
4.1
ultrasonicsoft

Hi There, I have very strong hands on SQL Server and Oracle. I have created very complex SPs in SQL Server using CTE etc. I have also generated dynamic queries and worked on complex types. I would like to conver More

$250 USD in 3 days
(5 Reviews)
2.1
ekajgho

Over 15 years of experience in Microsoft Technologies. MCTS (Microsoft Certified Technology Specialist) on Web Applications Development with Microsoft .NET Framework 4 (Exam Code: 070-515). Functional experience incl More

$111 USD in 3 days
(3 Reviews)
2.4
bsdelnik

Hello, i'm new to the site. This is my first bid, so in order to raise my rating I will do your task on the best price and as quick as possible. Hope you will like it.

$30 USD in 1 day
(2 Reviews)
1.5
KevinZC

Dear You, I am really interested to work on this project, I can start the work now , and can provide the best services from my end. Please come on chat to discuss more about the project. Thanks!

$144 USD in 3 days
(0 Reviews)
0.0
jagan968

I have an excellent exeriance in writing stored procedures in various database technologies like teradata, oracle and sql server. I worked on building enterprise common procedures for one of the top banks in US. You ca More

$111 USD in 3 days
(0 Reviews)
0.0
nksundaram

Experienced software professional with over 20 years in design and development of software. Good with MS SQL and Oracle

$138 USD in 3 days
(0 Reviews)
0.0
artgerasimov

A proposal has not yet been provided

$177 USD in 3 days
(0 Reviews)
0.0
ddruzak

I have been working in PL/SQL for the last 3 years continuously and have the Oracle Certified Associate certificate. Also, I have both Oracle DB and SQL Server installed and ready for use. Important notice: I have a More

$144 USD in 3 days
(0 Reviews)
0.0
anindita2020

Seeing the code snippet, it doesn't look like its complex Should be a easy one. However after converting it to Oracle, we obviously need to get it tested in any of the Oracle environments you have. I can work wi More

$155 USD in 3 days
(0 Reviews)
0.0
tayyab4u

A highly motivated, first class Computer Science graduate with keen interest in technology and business as well as a high level experience in developing financial applications and web applications.

$160 USD in 3 days
(0 Reviews)
0.0