Home » Other » General » Display on SQL Plus
Display on SQL Plus [message #102417] Sun, 26 May 2002 23:31 Go to next message
mandar rajurkar
Messages: 1
Registered: May 2002
Junior Member
I want my result displayed on the SQL*Plus prompt to stop pagewise if it in multipages.
I would be able to manually intervene and see next page's result by pressing some key.
Re: Display on SQL Plus [message #102418 is a reply to message #102417] Mon, 27 May 2002 08:13 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use

sql> set pause on

the screen will be scrolled to next page when u hit "enter" or carriage return.

Note:
you can define you own SIZE for the page
by

sql> set pagesize 25
Previous Topic: dbams_obfuscation_toolkit package
Next Topic: Question Papers
Goto Forum:
  


Current Time: Fri Mar 29 06:25:53 CDT 2024