Convert Stored Procedure (Oracle to MySQL)

In Progress Posted Nov 10, 2015 Paid on delivery
In Progress Paid on delivery

I need an Oracle stored procedure (PL/SQL) converted into a MySQL stored procedure. The Oracle procedure is not long at all, around 100 lines. It does a pivot. Basically I have data that looks like this...

TEMP-TABLE

------------------

JOE / 123 / AAA / 111

JOE / 123 / BBB / 222

And it converts it into this...

FINAL-TABLE

------------------

JOE / 123 / AAA / 111 / BBB / 222

That's an overly simplified version of what it does. In reality there are more columns and dups must be ignored, but I'm pretty sure it is your basic "pivot" concept. I cannot supply the data, only the Oracle code (which I know works). I just need it converted into MySQL. The end result must work on:

innodb_version: 5.5.37

protocol_version: 10

slave_type_conversions:

version: 5.5.37-cll-lve

version_comment: MySQL Community Server (GPL) by Atomicorp

version_compile_machine: x86_64

version_compile_os: Linux

I just uploaded the Oracle version. Please take a look.

Database Programming MySQL Oracle

Project ID: #8877440

About the project

6 proposals Remote project Active Nov 10, 2015

Awarded to:

vinaysinghh

A proposal has not yet been provided

$30 USD in 1 day
(58 Reviews)
5.3

6 freelancers are bidding on average $42 for this job

mail2vimalarora

Hi, I have gone through your project details of conversion of stored procedure and can provide you solution in MYSQL. I have good knowledge of working on Oracle and MYSQL database both. I just need Oracle code you ha More

$40 USD in 1 day
(48 Reviews)
5.1
DHSprout

A proposal has not yet been provided

$28 USD in 1 day
(21 Reviews)
5.2
francomahl

Hello, I am able to do this job. I have been working with databases for 3 years. I am familiar with both Oracle and MySQL.

$35 USD in 3 days
(0 Reviews)
0.0
Taiyo07

La propuesta todavía no ha sido proveída

$40 USD in 3 days
(0 Reviews)
0.0