OraFAQ Forum: Server Administration » How to use sql*plus to interactive with user?

Home » RDBMS Server » Server Administration » How to use sql*plus to interactive with user?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to use sql*plus to interactive with user? [message #370153]

Mon, 25 December 2000 07:27

Kevin J.
Messages: 3
Registered: October 2000

Junior Member

Hi :
I want to write scripts in sql*plus to interactive with user :
accept ans promt 'pls input your answer :'
begin
if :ans='1' then
-- do something
else
-- do other things
end if;
end;
/
How can I make it

Report message to a moderator

Re: How to use sql*plus to interactive with user? [message #370155 is a reply to message #370153]

Mon, 25 December 2000 22:38

Balasubramanian.C
Messages: 5
Registered: November 2000

Junior Member

hi,
try and use substitution variable like '&' (ampersand)

Report message to a moderator

Re: How to use sql*plus to interactive with user? [message #370156 is a reply to message #370153]

Mon, 25 December 2000 22:46

P. Lavanya
Messages: 8
Registered: November 2000

Junior Member

Hi,

Try this:

SQL> PROMPT 'PLEASE INPUT YOUR ANSWER:'
SQL> ACCEPT ANS
SQL> BEGIN
SQL> IF '&ANS' = '1' THEN
SQL> ------
SQL> ELSE
SQL> -----
SQL> END IF;
SQL> END;

lavP

Report message to a moderator

Previous Topic:	How to find all the sequences I have created?
Next Topic:	sqlplus query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 23:15:03 CDT 2024