Thread: Oracle Update Query
10-21-09, 16:03 #1Registered User
- Join Date
- Oct 2009
Unanswered: Oracle Update Query
I'm trying to update a field (ASSET_HANSEN_CENTRELINE.STREET) with a street name that comes from the IMSV7.STREET table linked through the IMSV7.COMPSEG table by an STKEYfield.
I've attached an ERD for further explaniation.
here's my code so far
UPDATE GISDBA.ASSET_HANSEN_CENTRELINE C SET C.STREET =
(SELECT A.STNAME FROM IMSV7.STREET@PROD.WORLD A
WHERE A.STKEY =
(SELECT B.STKEY FROM IMSV7.COMPSEG@PROD.WORLD B
WHERE (B.STKEY = A.STKEY) AND C.SEGID = B.MAPNO));
what do you think? It runs forever so I'm not sure if its working.
10-21-09, 16:19 #2Registered User
Provided Answers: 1Code:
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
UPDATE gisdba.asset_hansen_centreline c SET c.street = (SELECT a.stname FROM firstname.lastname@example.org a WHERE a.stkey = (SELECT b.stkey FROM email@example.com b WHERE (b.stkey = a.stkey) AND c.segid = b.mapno));You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.