| Execute statements after every 'Enter' [message #2945] |
Fri, 23 August 2002 15:52  |
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
|
|
|
|
|
|
| Re: Execute statements after every 'Enter' [message #2957 is a reply to message #2945] |
Sun, 25 August 2002 21:51  |
swapna
Messages: 11
Registered: May 2002
|
Junior Member |
|
|
put set pause on between each sql
i.e.,
SELECT ename, job, sal Salary
FROM EMP
/
set pause on ;
SELECT *
FROM SALGRADE
/
set pause on ;
SELECT empno, ename,
sal*12 "ANNUAL SALARY"
FROM EMP
/
set pause on ;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
