Default login. SQL configuration for Oracle

SQL * PLUS allows you to create a login. SQL file. This script is executed every time SQL * PLUS is started. In addition, you can create an SQLPATH environment variable.

SQL * PLUS allows you to create a login. SQL file. This script is executed every time SQL * PLUS is started. In addition, you can create an SQLPATH environment variable.

SQL * PLUS allows you to create a login. SQL file. This script is executed every time SQL * PLUS is started. In addition, you can create an SQLPATH environment variable. In this way, no matter which directory the login. SQL script is located, SQL * PLUS will find it.

1. Create a login. SQL script file and put login. SQL IN THE/home/Oracle/oracle_install_file directory. The content is as follows:

[Oracle @ localhost oracle_install_file] $ nl login. SQL

1 define _ editor = vi

2 set server output on size 1000000

2. Add the following record to the. bash_profile hidden file in the home directory:

Export SQLPATH =/home/oracle/oracle_install_file

,