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
Messages: 500
Registered: December 2008
Senior Member
hi i am having tables like

both EMRPatientProblems and EMRUncodedProblems are having three common columns in it like

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
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: Fri Oct 28 18:27:33 CDT 2016

Total time taken to generate the page: 0.17002 seconds