Snippet Name: Prompts
Description: A sample of using prompts.
Comment: (none)
Language:
Highlight Mode: PLSQL
Last Modified: March 02nd, 2009
|
accept newuser CHAR PROMPT 'Enter NEW Oracle User: ';
accept fuser CHAR PROMPT 'Enter FROM Oracle User: ';
UPDATE sy_user_id
SET user_ref = '&newuser',
des1 = '&newuser'
WHERE user_ref = '&fuser'
/
UPDATE rq_approval_order
SET user_ref = '&newuser'
WHERE user_ref = '&fuser'
/
UPDATE sy_user_bom
SET user_ref = '&newuser'
WHERE user_ref = '&fuser'
/
UPDATE oe_notes_audience
SET user_ref = '&newuser'
WHERE user_ref = '&fuser'
/
UPDATE ar_customer_master
SET collect_user_ref = '&newuser'
WHERE collect_user_ref = '&fuser'
/
UPDATE im_item_loc
SET def_po_agent = '&newuser'
WHERE def_po_agent = '&fuser'
/
UPDATE po_hdr
SET po_agent = '&newuser'
WHERE po_agent = '&fuser'
/
UPDATE po_loc
SET def_po_agent = '&newuser'
WHERE def_po_agent = '&fuser'
/
UPDATE po_rechst_line
SET po_agent = '&newuser'
WHERE po_agent = '&fuser'
/
UPDATE po_rechst_ord
SET po_agent = '&newuser'
WHERE po_agent = '&fuser'
/
UPDATE po_line
SET user_ref = '&newuser'
WHERE user_ref = '&fuser'
/
UPDATE rq_hdr
SET user_ref = '&newuser'
WHERE user_ref = '&fuser'
/
UPDATE rq_item_request
SET req_user_ref = '&newuser'
WHERE req_user_ref = '&fuser'
/
UPDATE rq_line
SET user_ref = '&newuser'
WHERE user_ref = '&fuser'
/
UPDATE rq_rfq_hdr
SET user_ref = '&newuser'
WHERE user_ref = '&fuser'
/
|