No question at this time
DBA Top 10
1 M. Cadot 26200
2 A. Kavsek 16900
3 B. Vroman 11000
4 M. Hidayathullah ... 10500
5 T. Boles 7600
6 F. Diaz 6700
7 P. Wisse 6400
8 J. Schnackenberg 4700
9 A. Hudspith 4500
10 P. Knibbs 2500
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users47898
Total active users1919
Act. users last 24h13
Act. users last hour1
Registered user hits last week245
Registered user hits last month1316
Go up

Oracle sqlplus scrolling interruption
Next thread: user restriction or control
Prev thread: Bulk-Load in a Local-Index-Table

Message Score Author Date
I normally use Unix, but need to support Windows a...... Stephanie Gonos Feb 09, 2017, 22:31
Dear, open another session find out sid of that...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Mirza Hidayathullah Baig Feb 10, 2017, 08:12
The issue is not with SQL*Plus, it is with DOS. ...... Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts Michel Cadot Feb 10, 2017, 08:54
Thanks for sharing below info Michel! You can s...... raghavendra rao yella Mar 02, 2017, 22:34

Follow up by mail Click here


Subject: Oracle sqlplus scrolling interruption
Author: Stephanie Gonos, United States
Date: Feb 09, 2017, 22:31, 41 days ago
Os info: Windows 2003 SP1
Oracle info: 12C
Error info: none
Message: I normally use Unix, but need to support Windows as well. I bring up a command prompt and login to SQLPLUS. When I issue a select and the numbers of rows it comes back with are many, I used to be able to do a control D and get it to stop, and still keep my SQLPLUS window open. I find that doesn't work. What commands, Function Keys can I use to interrupt the results of a query that are much longer than I care to see ?

Thank You
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Oracle sqlplus scrolling interruption
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Feb 10, 2017, 08:12, 41 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Dear,

open another session find out sid of that session and kill.

for killing session refer below links

https://support.oracle.com/epmos/faces/CommunityDisplay?resultUrl=https%3A%2F%2Fcommunity.oracle.com%2Fthread%2F3578701&_afrLoop=513549676487950&resultTitle=DB-Session+still+running+when+sqlplus-prozess+was+killed&commId=3578701&displayIndex=2&_afrWindowMode=0&_adf.ctrl-state=ymfjo59oi_29

https://oracle-base.com/articles/misc/killing-oracle-sessions

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Oracle sqlplus scrolling interruption
Author: Michel Cadot, France
Date: Feb 10, 2017, 08:54, 41 days ago
Score:   Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts
Message:
The issue is not with SQL*Plus, it is with DOS.
You can suspend the result display using Ctl-S and resume it using Ctl-Q.
You can stop the result with Ctl-C but this works (sometimes) ONLY for the first time you use it in a SQL*Plus session, the second time it kills SQL*Plus.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Oracle sqlplus scrolling interruption
Author: raghavendra rao yella, United States
Date: Mar 02, 2017, 22:34, 20 days ago
Message: Thanks for sharing below info Michel!

You can suspend the result display using Ctl-S and resume it using Ctl-Q.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here