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

Name

SET RECSEPCHAR

Synopsis

The RECSEPCHAR setting changes the record separator to something other than a line of space characters.

Syntax

SET RECSEPCHAR separator_char

Parameters

separator_char

Is the character you want to use in the record separator line. The default value is a space.

Examples

The default record separator is a blank line. The following example shows how you can change it to be a line of asterisks instead:

SQL> SET RECSEPCHAR "*"
SQL> SET RECSEP EACH
SQL> SELECT view_name FROM all_views;
ALL_ALL_TABLES
********************************************************
ALL_ARGUMENTS
********************************************************
ALL_CATALOG
********************************************************

This example uses SET RECSEP EACH to cause a separator to print after each record, so you will see something. The separator character was set to an asterisk, causing you to get a full line of asterisks between each record. The length of the separator line will match the LINESIZE setting.