Quick Search:
 
 Oracle PL/SQL: Prompts Jump to:  
Category: >> Oracle PL/SQL >> Prompts  

<< lastnext >>

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'
/
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org