Find Jobs
Hire Freelancers

Convert Stored Proc/Function from SQL Server to Oracle

$30-250 USD

Cancelled
Posted over 8 years ago

$30-250 USD

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.
Project ID: 9531283

About the project

20 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
20 freelancers are bidding on average $154 USD for this job
User Avatar
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 at the sproc & function that you attached & this sounds like a fairly straight forward project to me.
$175 USD in 3 days
5.0 (27 reviews)
7.1
7.1
User Avatar
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
4.9 (10 reviews)
4.5
4.5
User Avatar
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 plsql packages for the telecom company in last 7 years. I will be glad to work for you on this project. Regards
$111 USD in 3 days
4.8 (26 reviews)
4.6
4.6
User Avatar
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, Database Migration Assistant, OEM, SQL/Oracle Trace, EXP/IMP, SQL*Loader, RMAN, DataPump, AWR, ADDM, oracle forms,Reports,EBS. I Can do your work easily. Let me know when we can discuss.
$155 USD in 3 days
4.2 (32 reviews)
5.6
5.6
User Avatar
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 comment code. - Prefer to maintain good relations ---- *please discus before award project Lets discus... >>> --- Feel free to ask any query
$170 USD in 3 days
4.9 (26 reviews)
4.2
4.2
User Avatar
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,writing complex queries,performance tuning in both SQL server and Oracle so would be the best fit for the project. We have 100% completion rate,please check our reviews to have an idea about the quality of work we have delivered in the past. If given a chance I assure you of the best quality work within time and budget. Regards NK
$211 USD in 3 days
5.0 (8 reviews)
4.1
4.1
User Avatar
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 includes Telecom Application, Financial Application, ERP-Application, School Application and development of user interface elements for embedded software. Having good knowledge and skills in OOPS (Object Oriented Programming), ASP.net with C# & VB, Web services (SOAP, WSDL), WCF, WPF, MVC, Entity Framework, Visual Basic, Crystal Report, SSIS & SSRS, MS SQL Server, Oracle and MS Access. Experience in working VS2012, VS2013 and VS2014 with AngularJS, Knockoutjs, Bootstrap css Telerik Controls etc all advanced technologies. Having experience in MEAN Stack (MongoDB, Express JS, Angular JS, Node JS). I have a ready made code for it and can quickly deliver with few tweaks only. Very committed to deliver products matching with requirements on or before time. I will develop and give demonstration frequently to match your expectations. For any clarifications, contact me.
$111 USD in 3 days
4.8 (6 reviews)
3.1
3.1
User Avatar
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 convert your SQL SP to Oracle one. Question: Does this SP need special data in table? If Yes, could you please provide the same? Looking forward to hear from you soon. Best Regards, Balram
$250 USD in 3 days
5.0 (5 reviews)
2.0
2.0
User Avatar
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
5.0 (2 reviews)
1.5
1.5
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
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 can expect the best within your deadlines. Let me know if you are interested.
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
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 already done more than half the task. I will, most likely, have it completed by evening EST tomorrow.
$144 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 with you to get the new script tested and get it in running condition. And my bid includes this testing activity ( doesn't matter if it spills over 3 days ).....and can spend 3 more days on testing activity I will be happy to help.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Vancouver, United States
5.0
8
Member since Nov 7, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.