Learning Linux Shell Scripting - Second Edition

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 ...