Tamamlanmış

Convert a Oracle SQL to MariaDB.

I looking for SQL experts.

I have Oracle Query which is using WITH and ROWNUM .

And I 'd like to convert it to MariaDB SQL.

Unfortunately MariaDB do very limited support for WITH and ROW_NUMBER in latest version(10.2).

For example, both ROW_NUMBER() and WITH statement can not be used in one SQL statement.

ORACLE SQL is attached.

If someone is project awarded, I will let you know a ORACLE and MariaDB(10.2) Access information,So you can test it on two environment.

If this is completed, additional 5 SQL to be converted in next project

Beceriler: MariaDB, MySQL, SQL

Daha fazlasını gör: convert oracle ddl to mysql, oracle to mysql migration tool free download, oracle to mysql migration tool online, convert oracle to mysql open source, oracle to mysql migration using mysql workbench, oracle to mysql converter free, sql to oracle query converter online, oracle to mysql migration issues, convert oracle sql scripts sql server scripts, convert oracle sql script microsoft sql script, convert oracle sql script mssql, convert oracle sql server scripts, convert oracle sql 2005, convert data sql oracle 10g, convert oracle script sql server script

İşveren Hakkında:
( 46 değerlendirme ) SEOUL, Korea, Republic of

Proje NO: #14896213

Seçilen:

softcarve

MM. Hi, I would like to convert your oracle query having cte and row number to maria db query. Please share details. So that we can take things forward. Thanks.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(57 Değerlendirme)
5.4

Bu iş için 20 freelancer ortalamada $119 teklif veriyor

truongnguyen86

Hello there, i'm expert on Oracle, honestly i don't have a chance to work with MariaDB but i think i can handle this for you because with statement is just only the alias for a set of data so instead of trying to use w Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(140 Değerlendirme)
6.5
keshavkalra90

Hi there, I am a SQL expert, I can convert it to MariaDB SQL. As per your requirements, i find myself fit for the position. I have been in the web industry for the last 4 years providing customized solutions to my Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(70 Değerlendirme)
6.1
in %bids___i_period_sub_35% gün içinde98%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(27 Değerlendirme)
4.9
Sndeep88

Hello, Having read your job description, I feel to be a good fit for this job, as I have hands on experience working on the PHP, Mysql, HTML, JQuery Frameworks, as well as Major CMS's like Joomla, WordPress and Mag Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)
4.9
imagicaworld

Dear Client , We are Really interested to do work with you , We are Web & Software development company having more than 6 year experience in Software development we totally committed to quality service, Transparen Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)
5.1
vinaysinghh

i am oracle and mysql dba having more then 10 yrs of exp.......................................................................................................................................

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(52 Değerlendirme)
5.1
bhupen2606

Hi, i have an idea, instead of using WITH, we can try nested select. Let me know if you would like me to try this on your system.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(23 Değerlendirme)
4.3
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
3.3
MetaoriginLab

We are a Team of Technical Consultants and Data Engineers having healthy experience into Big Data technologies,IOT/Cloud/AWS and Python/AI+Machine Learning. The Dynamic force has qualified engineers having expertise in Daha Fazla

in %bids___i_period_sub_35% gün içinde134%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
3.4
AccuPro

I am very very good at Oracle sql.. However, i will need to look into Maria db to review its sql capabilities.. But i have always found alternative methods to solve such issues earlier. would appreciate getting more i Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)
3.5
enterpriseit1

hi, i saw the oracle query that you have provided and i can convert it to use with MariaDB or MySql db. Maria Or mysql doesn't support the inline view that oracle offers with the help of 'WITH' syntax. The structu Daha Fazla

in %bids___i_period_sub_35% gün içinde77%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
3.6
veskojl

Hi, I'm a DB expert from Bulgaria(EU) with strong experience in wide variety of RDBMS: MySQL, PostgreSQL, MS SQL Server, Oracle, Teradata and a few others.. I have a solid knowledge in writing and tuning complex Daha Fazla

in %bids___i_period_sub_35% gün içinde110%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
3.4
pratikgedia

I have converted many Oracle SQL to various versions like MySQL, Mssql, Postgre etc. and also have experience in Maria DB . Could you please have a chat discussion and we shall work on it?

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
2.2
HelloWebStar

I'm available to discuss more on your project, I will provide 24/7 support and quick response guaranteed! So feel free to contact me at any time! I will give you full service and maintenance also for my work so if y Daha Fazla

in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)
1.9
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
1.9
GeraldoViana

Wich version of MariaDB are you using? From 10.2.1 onwards WITH Clause is supported and from 10.2.2 WITH Recursive was available too. ROW_NUMBER was introduced with WIndow Funtions in 10.2. So I strongly suggest you up Daha Fazla

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
0.0
lonxu2017

Hi, there. I have read your proposal. I have good experience with Database Management. I can help you. Please contact me. Regards.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
0.0
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
AlexShevchen

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde82%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0