Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Name

SET EMBEDDED

Synopsis

The EMBEDDED setting command controls the printing of embedded reports. The default setting is OFF, which causes the results of each new query to print on a new page and causes page numbering to start over each time a SELECT statement is executed.

Syntax

SET EMB[EDDED] {ON | OFF}

Parameters

SET EMB[EDDED]

Is the command, which may be abbreviated SET EMB.

ON

Turns the embedded report feature on. Executing a SELECT statement will not force a page break, nor will it reset the page number.

OFF

Turns the embedded report feature off. Executing a SELECT statement will force a page break, and the page number will be reset to 1.

Examples

An embedded report is one that prints as if it were the continuation of a previous report. The following example shows the results of executing two SELECT statements with the default setting. A page title has been created to show the effect on page numbering:

SQL> SET EMBEDDED OFF
SQL> SET PAGESIZE 24
SQL> SET NEWPAGE 1
SQL> TTITLE LEFT "Example of SET EMBEDDED, Page " SQL.PNO
SQL> SELECT * FROM dual;
Example of SET EMBEDDED, Page         1
D
-
X
SQL> SELECT * FROM dual;
Example of SET EMBEDDED, Page         1
D
-
X

The second SELECT statement generated a page break; you can see the page title printed again. By looking at the titles, the page numbering for each query began with page one. Look at the same example but with SET EMBEDDED ON:

SQL> SET EMBEDDED OFF
SQL> SET PAGESIZE 24
SQL> SET NEWPAGE 1
SQL> TTITLE LEFT "Example of SET EMBEDDED, Page " SQL.PNO SQL> ...