convert MS excel data to oracle select statement

Completed Posted Jan 26, 2015 Paid on delivery
Completed Paid on delivery

Requirement:Convert the Microsoft excel spreadsheet data into oracle select statements.

Rules:

1:Sample data file attached. Last column in the spreadsheet(DATA tab), has a field name SQL. This should have the formula

2: When the sql is executed in oracle database, it should look like below

example

"select 'a' name,'b' addr from dual union all

select 'c' name,'d' addr from dual union all

select 'e' name,'f' addr from dual";

3. If there are any empty fields in excel, then they are considered as null in oracle sql statement.

4. It should be a simple excel formula and there should not be any VBA code involved. Excel Formula should be easy to understand and can be applied to similar data set for other spreadsheets as well

.

Excel Oracle SQL

Project ID: #7037778

About the project

6 proposals Remote project Active Jan 27, 2015

Awarded to:

expertatwork

We can use formulas to create Select statements...please reply..we can get started...thank you... !

$35 USD in 1 day
(152 Reviews)
5.8

6 freelancers are bidding on average $29 for this job

ramehani

Hi i have more than 7 years of experience in oracle and excel works i can do this for you. in a quick and easiest manner.

$25 USD in 1 day
(8 Reviews)
2.9
ENRICOJ

========================================================================= I HAVE STRONG DATA CLEANING,INTEGRATION AND DESIGN SKILLS. I AM A MICROSOFT CERTIFIED DATABASE DEVELOPER AND ALSO HAVE STRONG EXPERIENCE WITH More

$30 USD in 1 day
(3 Reviews)
1.9
asharfraz

dear sir, i have read and understood your project requirements, i can do this task in fast pace, if you are interested in having your job done in less than one day. kindly PM. thanking you in anticipation. Cheers More

$35 USD in 1 day
(0 Reviews)
0.0
VinithaThankam

I have previous experience in similar projects at my work place. Quality work and timely delivery is what I am known for!

$20 USD in 1 day
(0 Reviews)
0.0
bandarupallibnk

A proposal has not yet been provided

$27 USD in 1 day
(0 Reviews)
0.0