...
Special Considerations
login.sql
The script that you provided in the input FDSQLPLUS_INP_LOGIN_SQL_FILE
will be created as the login.sql file in the current working directory and will be deleted after execution. The login.sql script file in SQLPlus is automatically executed automatically whenever you start SQLPlus. It can be used to set up your SQL*Plus environment, including setting formatting options, environment variables, and other session settings.
Below the is the an example script . we that can customize be customized based on requirementrequirements.
Code Block |
---|
-- Set the SQL*Plus environment settings SET ECHO OFF SET FEEDBACK ON SET HEADING ON SET LINESIZE 200 SET PAGESIZE 9999 SET SERVEROUTPUT ON SET TERMOUT ON SET TIMING ON SET VERIFY OFF -- Set default schema ALTER SESSION SET CURRENT_SCHEMA=YOUR_SCHEMA_NAME; -- Define common substitution variables DEFINE my_variable = 'default_value' -- Custom SQL*Plus prompt SET SQLPROMPT "SQL> " -- Display a welcome message PROMPT Welcome to SQL*Plus |
...