convert MS excel data to oracle select statement

Completado Publicado Jan 26, 2015 Pagado a la entrega
Completado Pagado a la entrega

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

Nº del proyecto: #7037778

Sobre el proyecto

6 propuestas Proyecto remoto Activo Jan 27, 2015

Adjudicado a:

expertatwork

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

$35 USD en 1 día
(152 comentarios)
5.8

6 freelancers están ofertando un promedio de $29 por este trabajo

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 en 1 día
(8 comentarios)
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 Más

$30 USD en 1 día
(3 comentarios)
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 Más

$35 USD en 1 día
(0 comentarios)
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 en 1 día
(0 comentarios)
0.0
bandarupallibnk

A proposal has not yet been provided

$27 USD en 1 día
(0 comentarios)
0.0