Update data to upper case in parent/child tables

Posted on 16th Feb 2014 07:03 pm by admin

Hi Gurus!

In production we have a product table and which is being reference by many tables making it parent child relationship. By mistake, we realized that last month some product were added in lower case and now we got a request to update all these product codes to upper case so that the existing code that use these tables have no impact. Appreciate if you can give some idea on how can I update the existing data in the parent table to upper case along with the child records?

Regards

Your Answer:

Login to answer

Other forums

Variable uses and placement
I'm new to PL/SQL and am trying to learn about variable valid uses/placement (any pointers to any do

MySQL issue
I am taking sentences through a form on page. Then checking some condition and trying to insert them

PHP url branch??
Functionally, using PHP, I'm doing a test of login input submitted by a user via an html form in a f

Linking with Foreign Keys
I have been getting an erro when I try and link:

create table Faculty_Specialty (I_Name v

Problems with adding a link to one position in a 'foreach' loop, please help
Hello!

Iam pretty new to programming and I wanna create a table with users from an array. It

do while...woes
I'm sure this is childsplay but it is stumping me, everytime i try what I think would make this work

Display a default image
I am trying to display generic image for items that don't have one, but I can't get it to display.

rename the file
File.txt

Code: ***DOCUMENT***
..DN:
000044255
..CB:
..SN:
..PY:
2009
..E

Problems with strings containing
Hey all,

I have encountered something strange in a script. I am trying to write an XML heade

Looking for help on using joining mysql tables and php....
Does anyone have any good links to references on how to pull mysql data, through joining tables and