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