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

Please help with code for SMTP authenticated PHP email form
Hello, I'm creating a PHP email form, and for this particular server, I have to use SMTP Authenticat

need help with php get
i have a option box that gets filled with dates, but how do i get once the option value has been cli

Only add new information from XML to MySQL
What I am doing, is taking a xml file, and adding the values to a database. However, what I want to

Get to know your fellow coder
I think it's time we got personal around here. There's a lot of code swapping and a few members kno

Mail functionality from localhost to server
Hi

I am facing problem of mail functionality.

When i tested mail functionality in my

PHP Include not working
The website is http://www.grlistingservices.com

The code block is as follows:

<

modifying query string with no page refresh
Hi everybody,
I've tried to get info about my problem all over the internet but i didn't find out

Renaming a file that a user uploads to site?
My site allows for registered users to upload images to the site under their own gallery. Currently

Create or replace package is ending ORA-21700
Database 9.2.0., patch 8 (9.2.0.8.0).
I trying run
create or replace package ....etc.

Feed Maker
Hi all.
First of all I must say I am not a php developer so I am afraid I don't know much about i