Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sql - Prompt y/n for next sql query

User_9QK9IJun 13 2017 — edited Jun 14 2017

     Hi, Is there any way i can get the prompt to put user input yes/or not to run or not to run the next sql query

fo example

a.sql

select name from v$database

select name from v$datafile

exit

I want to run 2nd query based on user input YES if user says NO it should exist out

any way?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2017
Added on Jun 13 2017
10 comments
1,027 views