Predefined variables

During the installation of SQL*Plus, eight variables are created and initialized. We will refer to them as predefined variables.

Variables

Description

_CONNECT_IDENTIFIER

Identifier of connection if available.

_DATE

Current date

_EDITOR

Information of editor used by EDIT command.

_O_RELEASE

Detailed release number of Oracle Database.

_O_VERSION

Version of installed Oracle database.

_PRIVILEGE

Current users privilege level

_SQLPLUS_RELEASE

Details of installed SQL*Plus component.

_USER

Name of the user

Let's create the script oracle_01.sh to get information about the predefined variables:

#!/bin/bash sqlplus user1/Test123 <<MY_QUERY define MY_QUERY Save the script ...

Get Learning Linux Shell Scripting - Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.