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: Tue Jul 25 06:15:05 CDT 2017

Total time taken to generate the page: 0.13090 seconds