SQL queries for Oracle

$10-30 USD

Closed

Posted

almost 7 years ago

$10-30 USD

Paid on delivery

Attached is a spreadsheet that has 4 tabs - Input 1, Input 2 are 2 different versions of data. Output 1 and Output 2 are the expected tables to be created in Oracle using the input files. There are arithmetic rules that need to be executed to get the output. Flow is: 1. Receive Input 1 2. Upload excel/csv input in Oracle output table 3. Use the arithmetic operator, weightage type and weight to calculate - "for info" column explains the calculation that needs to be done and how it should be done. SQL query needs to be written for that 4. Output 1 relates to file Input 1- timestamp column is needed. 5. In next iteration, user may receive Input 2 where some things have changed 6. The same steps from 1 - 3 need to be repeated. Simple/easy project for someone with SQL skills so shouldn't take more than an hour.

Database Programming

Oracle

SQL

Project ID: 14052184

About the project

47 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

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

47 freelancers are bidding on average $41 USD for this job

@schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply

$100 USD in 1 day

5.0

(11 reviews)

5.5

@mail2vimalarora

Hi, I have gone through your project details and would like to take an opportunity to work on it. Being experienced in working on several projects related to Oracle SQL and similar tasks, I can help you out in getting it done quickly and efficiently. Waiting for your response for further discussion. Thanks.

$25 USD in 0 day

4.9

(85 reviews)

5.7

@axiomswb

we have expertise in Oracle,SQL,MySQL, DBA, Data processing. Client satisfaction is our main motto for long term relationship.

$25 USD in 1 day

4.9

(23 reviews)

5.4

@srinichal

Ready to discuss further details as I am an expert in automation and delivering custom softwares and scripts

$66 USD in 4 days

5.0

(3 reviews)

5.0

@jagdishbhatt38

I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utilizing my knowledge and skills.

$45 USD in 2 days

4.9

(28 reviews)

4.8

@shahzaib121

Hi Dear I have a lot of experience in DataBases ,Data Warehous,DB2 , Teradata etc . I am DataBases + Warehouse certified from Oracle,postgresSQL,SQL SERVER , Access. I have done many work in Requirements analysis , Data Staging, Data Warehouse, DataBases. I am expert in developing ERD, Front-End, Backend, Security, Optimization, SSIS, SSRS. I have strong command on queries too.I see your work & too much interesting in your work. My rates is also too much low. I assure you I am the best for your work. Kindly reply me so that we negotiate on price & then start working on it Have a good day Thank you

$25 USD in 2 days

4.8

(21 reviews)

4.7

@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 will be glad to work for you on this project. Regards

$35 USD in 1 day

4.8

(26 reviews)

4.4

@Wahid1978

Hello Sir, I have gone through your requirement and got your requirement perfectly. I am ready to deliver the project within one day. Steps to be done: a. Get the group by data of "Source" for each "level" to generate "Source" value in output table b. For each level calculate the value based on Arithmetic, weightage type and weightage c. For output table2 additional one script to be ready for different type arithmetic calculation. May be your info "BCD605*0.6 + BCD606 - 0.6*BCD607 - 0.6*BCD608 + BCD609 " not correct for the output2 table last calculation. Waiting to hear from you. Thanks Wahid

$30 USD in 1 day

4.7

(6 reviews)

3.7

@pratikgedia

Dear Sir/Madam, Hope you are doing well. Since this is my first project over here in as a Freelancer. Have understood the project and prepared all the necessary scripts that would be needed for this project. Also the scripts have been tested and upload to the test environment that was prepared and in the excel sheet there is a miscalculation for output 2 for label ABC126 which is given as 1993.2 actually it should be which was rectified using the script. I am having an 3.5 yrs experience of Oracle DBA and a Developer and certified Oracle DBA. As all the scripts are already prepared we will just need to understand the handover of scripts. Looking forward to hear from you soon. Thanks, Pratik Gedia

$10 USD in 0 day

4.7

(4 reviews)

3.3

@ouarkaayoub

Hi, I am interested in this project and I am available for new job, I know Html, css, Photoshop, MySql, Oracle,Java, J2EE, PHP, Nodejs,and some framework like LARAVEL, CAKEPHP and SLIM For more informations please contact me as soon as possible. Thank you. Dev OUARKA.

$20 USD in 2 days

4.9

(2 reviews)

2.1

@rishadbabu

..................................................................................................................................................................................................................................................

$25 USD in 1 day

0.0

(0 reviews)

0.0

@jumba2010

I have big sense of commitment. Together we can achieve your goals. Hire me

$35 USD in 1 day

0.0

(0 reviews)

0.0

@bchatterjee91

This is an ETL process. You need SQL*LOADER to load the excel sheet. And then just a simple query will do the rest. So if you need the excel files to be loaded with plsql script then it will be a different approach but the query will be same

$25 USD in 0 day