Closed

Oracle SQL Developer Query Loop

Need help creating loop attach is a document explaining what i am trying to complete

(h.person_f_name||' '||h.person_l_name) Witness_Name,

h.person_address Witness_Street_Address,

h.person_city Witness_City,

h.person_state Witness_State,

h.person_zip Witness_Zip,

h.person_home_phone Witness_Home_Phone_Number,

(e.compdrvr_f_name||' '||e.compdrvr_l_name) Second_Witness_Name,

e.compdrvr_address Second_Witness_Street_Address,

e.compdrvr_city Second_Witness_City,

e.compdrvr_state Second_Witness_State,

e.compdrvr_zip Second_Witness_Zip,

null Second_Witness_Home_Ph_Num,

e.compdrvr_office_phone Second_Witness_Bus_Ph_Num,

null Second_Wit_Relation_to_Claim,

null Second_Wit_Time_of_Acc_Desc,

-- Third_Witness_Name,

-- Third_Witness_Street,

-- Third_Witness_City,

-- Third_Witness_State,

-- Third_Witness_Zip,

-- Third_Witness_H_P_Num,

FROM

incident a

Left Join incident_witness_xref n

On a.incident_id=n.incident_id

Left Join person_info h

On n.person_id=h.person_id

Left Join comp_driver_info e

On n.compdrvr_id=e.compdrvr_id

Skills: Oracle, SQL

See more: sql developer loop query, query loop, oracle loop query, oracle sql developer loop, sql developer loop, sql query loop, n query, loop oracle developer, incident, creating sql, sql query help, oracle sql query, sql developer apex oracle, sql query oracle, developer oracle, oracle help, query oracle, oracle sql help, sql oracle converter

About the Employer:
( 12 reviews ) Dallas, United States

Project ID: #2518180

24 freelancers are bidding on average $93 for this job

nuprogramer

Please Check PM.

$250 USD in 2 days
(2 Reviews)
4.0
Codoc1010

Hi, my team has many expert programmers on .NET framework, C++, Sql Server 2005/2008. I sure, we can do your job on time with high quality. Please view my message for detail. Thanks!

$50 USD in 1 day
(8 Reviews)
3.8
sthakral

I understand your problem. Pls see PMB

$240 USD in 1 day
(4 Reviews)
3.8
NourElDeen

Dear sir, i'm SQL Expert. Kind Regards, NourELDeen

$45 USD in 5 days
(8 Reviews)
3.2
puneethmech

I can get this done!!

$50 USD in 2 days
(2 Reviews)
2.9
mslien

I can help you.

$65 USD in 3 days
(1 Review)
2.8
kkolukul

Having 7 yrs of experience in Oracle sql, plsql. Can finish your work in good quality and time

$80 USD in 2 days
(2 Reviews)
2.7
mageny

I work with SQL and PL/SQL since 1992, including ETL and Data Warehouse and I have Oracle Certified Professional (Internet Application Developer Rel. 6/6i). I was instructor of Oracle Academy in Brasil, including those More

$250 USD in 3 days
(2 Reviews)
2.5
ayaz12

Hello Sir! Plz Check PMB for detail. Thanks.

$50 USD in 1 day
(4 Reviews)
2.2
shael1

Hi I have read your project specifications. Please read the private message. Warm Regards, Shael.

$30 USD in 0 days
(2 Reviews)
2.1
norbware

Hello, with more than 10 years experience in the field of application development (also SQL, PLSQL,MS SQL, mySQL) I can start work on your project immediately. Regards

$90 USD in 1 day
(1 Review)
1.2
suffire

I've already got the solution. check pm.

$50 USD in 1 day
(1 Review)
1.0
abhisolutions22

i am expert in querying the data. Please give me the relation between tables in Diagrammatically.

$39 USD in 2 days
(0 Reviews)
0.0
RoopalOracleApps

I am working in Oracle since 7 years. I can do your work.

$60 USD in 7 days
(0 Reviews)
0.0
bluetrunk

Hi, I have 4 years of experience writing complex SQL Queries and can complete this task.

$40 USD in 3 days
(0 Reviews)
0.0
simsteve7

This should not be to hard, see PM.

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

Hi, I have 10 years of experience working in Oracle SQL & PL/SQL. I can write a query as per you requirement.

$75 USD in 2 days
(0 Reviews)
0.0
RusEngi

Give me more information about your task and I will do it

$33 USD in 5 days
(0 Reviews)
0.0
cajie

I have got a better understanding of your requirement and can deliver the solution withing 1 day.

$49 USD in 1 day
(0 Reviews)
0.0
bariksir44

Hi tamss13, I can give you the solution within 4 days. First you get 50% of the work from me, and then you decide whether to pay me or not. If you like the work, we can go ahead, else there is no compulsion. Hop More

$50 USD in 4 days
(0 Reviews)
0.0