Home » SQL & PL/SQL » SQL & PL/SQL » Execute statements after every 'Enter'
Execute statements after every 'Enter' [message #39922] Fri, 23 August 2002 15:33 Go to next message
Andonny
Messages: 6
Registered: August 2002
Junior Member
Hi,
I am a beginner and I am doing all these exercises. I have put them into an Ex1.sql which is fine. Then when I start the Ex1.sql it executes all select statements in there in one go. Is it possible to stop it after every select statement and only when I hit 'Enter' again it executes the next one and so on.

SELECT ename, job, sal Salary
FROM EMP
/
SELECT *
FROM SALGRADE
/
SELECT empno, ename,
sal*12 "ANNUAL SALARY"
FROM EMP
/

Thank you for your help
Andonny

Report message to a moderator

Re: Execute statements after every 'Enter' [message #39923 is a reply to message #39922] Fri, 23 August 2002 15:52 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
In sqlplus try:
SQL> set pause on

You can also enter dummy "accept" commands between statements:
accept DUMMY char prompt 'Press enter to continue:'

Report message to a moderator

Previous Topic: PL/SQL problem .
Next Topic: Re: SQL query problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 17:49:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.