Home » SQL & PL/SQL » SQL & PL/SQL » migration script (oracle 10g)
migration script [message #410316] Fri, 26 June 2009 03:19 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
hi i am having tables like
EMRPatientProblems
EMRUncodedProblems
EMRLocationMaster
EMRpatientsMaster
EMRDiagnosisCodesLkup

both EMRPatientProblems and EMRUncodedProblems are having three common columns in it like
PROBLEM_DESC,PROBLEM_CODE,STATUS

if the values are same for both tables then is_coded one column in
EMRPatientProblems tahtshould be updated to 1 as of now it is 0 for all rows .how can i achieve this?
and emruncodedproblems is having group_is column where emrpatientproblems is not having and emrlocationmaster is having group_is colukm where that values shold be taken into consideration.only based on the group specific i have to update the is_coded column values to 1.please help me out in this?



Re: migration script [message #410318 is a reply to message #410316] Fri, 26 June 2009 03:42 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Please take the time to rephrase your post.
Think what you want, either describe it functionally, or provide us with a test case showing your current situation and expected result.
Mixing these two result in totally abracadabra (at least to me).
Previous Topic: joining select statements
Next Topic: TO Loop 1 to 12
Goto Forum:
  


Current Time: Mon Dec 05 06:41:55 CST 2016

Total time taken to generate the page: 0.09901 seconds