Solved

how can we use set pause command

Posted on 2008-10-18
2
1,096 Views
Last Modified: 2013-12-18
How can we use set pause command
sp2 0311 error string expected but not found..
What is the reason?

0
Comment
Question by:dbaseek
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Expert Comment

by:Jankovsky
ID: 22749875
You have to use either
SET PAUSE ON
or
SET PAUSE OFF
Set pause on pauses after each page (according to SET PAGESIZE xxx ) and requires to press Enter (or Next in iSQL as written:)
0
 
LVL 15

Accepted Solution

by:
Shaju Kumbalath earned 500 total points
ID: 22750857
sp2-0311
SQL*Plus was expecting a string at the end of the command, but could not find it.
Retry the command with a valid string. Check the syntax of the command you used for the correct options.
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question