Home » SQL & PL/SQL » SQL & PL/SQL » Variable in PLSQL (PLSQL Version 9)
Variable in PLSQL [message #639611] Sun, 12 July 2015 07:16 Go to next message
rbs100
Messages: 6
Registered: July 2005
Junior Member
Hi,
I have a requirement to try.
Accept Sql variables in plsql.
Based on the input variables the loop must process commands.
For example, the program must prompt people 'whether to continue Y/N'.
Based on the input value, the loop can terminate or continue.
How do you write the program?
This I have tried many years ago. But I do not remember it.
-RBS

Report message to a moderator

Re: Variable in PLSQL [message #639613 is a reply to message #639611] Sun, 12 July 2015 07:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

PL/SQL does not interact with user.
Client program, for instance SQL*Plus, can.

Report message to a moderator

Re: Variable in PLSQL [message #639614 is a reply to message #639613] Sun, 12 July 2015 09:29 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post full results from SQL below

SELECT * FROM V$VERSION;

Report message to a moderator

Previous Topic: Swift message insert script
Next Topic: To tune a PL/SQL block
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Aug 11 04:13:24 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.