Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with ACCEPT Syntax
Hi Sean
use set verify off, an example:
SQL> set verify off
SQL> accept some_user prompt 'user to accept : '
user to accept : vpd
SQL> select username,password
2 from dba_users
3 where username=upper('&some_user');
USERNAME PASSWORD ------------------------------ ------------------------------ VPD 93AEF50C31AC2973
SQL> hth
kind regards
Pete
-- Pete Finnigan email:pete_at_petefinnigan.com Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details.Received on Fri Nov 14 2003 - 05:22:24 CST