Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help with ACCEPT Syntax

Re: Help with ACCEPT Syntax

From: Pete Finnigan <plsql_at_petefinnigan.com>
Date: Fri, 14 Nov 2003 11:22:24 +0000
Message-ID: <GVXh9xAwrLt$QxU9@peterfinnigan.demon.co.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US