Convert Stored Procedure (Oracle to MySQL) -- 2

完了済み 投稿 Nov 13, 2015 着払い
完了済み 着払い

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: [url removed, login to view]

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

***** MUST SEE PROGRESS AFTER 8 HOURS AND MUST BE COMPLETED WITHIN 24 HOURS *****

データベースプログラミング MySQL オラクル

プロジェクトID: #8897539

プロジェクトについて

1個の提案 リモートプロジェクト アクティブ Nov 13, 2015

アワード:

mail2vimalarora

Hi, As discussed, bidding on the project to convert oracle procedure to MYSQL format. Thanks for your invitation.

$40 USD 0日以内
(15レビュー)
3.7

1人のフリーランサーが、このジョブに平均$40で入札しています

prakashchavda

Hello buddy, I am java developer and have very good knowledge in pivot table, dynamic sql, Message me and send me the procedure to be converted into mysql.

$30 USD 1日以内
(0件のレビュー)
0.0