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

pop3 and fsockopen
So I am able to connect to the pop3 server, log in, and check how many messages there are. I am hav

please fix the error
What is the error in the below code ???
Line number On/Off | Expand/Contract <?php

email CODING Problem
Email coding problem.

I need to send a section of the info to $tf and the same as a Cc to $em

Track downloads' status
Hello,

I need to make somehow, some system, to track whether downloads are completed or faile

Rand() help needed
Hi all,

Can someone explain and give me a quick example of how I would go about this?

Need help with PHP/MySQL drop down menu
I need help on how I can implement a drop down menu which queries mysql database and output the avai

ALV List Display to point to another report on Double Click
Hi,

I want my ALV List Display to point to another report on Double Click on its line ite

How do I give a developer access to a specific directory and nothing else?
I want to give a develop access to a specific directory and nothing else

I can give them an F

PL/SQL: ORA-00947: not enough values error message
Hi all i am getting Error(25,63): PL/SQL: ORA-00947: not enough values error message when executing

Need understanding of this bit of code
Code: <?php
// WHERE clause filters
$arrSQLFilters = array();

//