Home » RDBMS Server » Server Utilities » How to Stop an answer while using SQL PLUS ?
How to Stop an answer while using SQL PLUS ? [message #72532] Fri, 11 July 2003 11:34 Go to next message
Upperm
Messages: 95
Registered: July 2003
Member
I'm a new Oracle User.
sometimes when I'm working on SQLPLUS,
I ask Queries and then get very long answers,
how can I stop this without canceling my session?

Report message to a moderator

Re: How to Stop an answer while using SQL PLUS ? [message #72534 is a reply to message #72532] Fri, 11 July 2003 20:23 Go to previous messageGo to next message
Chandan Singh
Messages: 14
Registered: July 2002
Junior Member
Hello
Either u can set Pause on to see long answers of those queries. If u want to cancel the answers in between press ALT + F + C.
To set Pause on.
write on Sql prompt
SQL> Set pause on
Sql> Select * from
;
I hope it will work for.
Bye

Report message to a moderator

Re: How to Stop an answer while using SQL PLUS ? [message #72600 is a reply to message #72532] Tue, 29 July 2003 03:09 Go to previous message
Patel Dhiren
Messages: 8
Registered: April 2003
Junior Member
PRESS ALT+F then type C to cancel

Report message to a moderator

Previous Topic: TNS & LISTENER
Next Topic: ora-01031: insufficient privileges
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 24 03:58:53 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.