SQL*Plus Environment Variables in Oracle

Q

What Are SQL*Plus Environment Variables in Oracle?

✍: FYIcenter.com

A

Behaviors of SQL*Plus are also controlled a some environment variables predefined on the local operating system. Here are some commonly used SQL*Plus environment variables:

  • ORACLE_HOME - The home directory where your Oracle client application is installed.
  • PATH - A list of directories where SQL*Plus will search for executable or DLL files. PATH should include $ORACLE_HOME\bin.
  • SQLPLUS - The directory where localization messages are stored. SQLPLUS should be set to $ORACLE_HOME\sqlplus\mesg
  • TNS_ADMIN - The directory where the connect identifier file, tnsnames.ora is located. TNS_ADMIN should be set to $ORACLE_HOME/network/admin.

 

Generate Query Output in HTML Format in Oracle

Show Current SQL*Plus System Settings in Oracle

Introduction to Command-Line SQL*Plus Client Tool

⇑⇑ Oracle Database Tutorials

2020-07-22, 2077🔥, 0💬