assigning stored data to a different identifier
Posted by: John Harris
Date: December 03, 2009 10:40AM

So here's my problem. There are a lot of item descriptions that I need to assign to another user for their usage. I know it sounds crazy, but that's the business rules.

For example, I have:

User_ID Item_Code Item_Desc
alpha 222 belt sander

I need to copy all Item_Code and Item_Desc to users beta, delta, gamma, theta...etc etc

I was thinking something along the lines of something resembling

Insert item_code.item, item_desc.item into table(user)
where user='beta';

and then running subsequent series from there.
I need to copy all the item_code, item_desc that are associated with one user_id and copy them to other IDs


Options: ReplyQuote

Written By
assigning stored data to a different identifier
December 03, 2009 10:40AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.