关于sqlplus的简单概述

sqlplus
interactive and batch query tool that is installed with every oracle database installation


SQL*PLUS Environment Variables


ORACLE_HOME:specify where oracle software is installer,it is also userd by SQL*PLUS to specify where message files are located
ORACLE_SID :to specify the database instance,ptional to SQL*PLUS
PATH:to specify the path to search for executables and DLLs in windows,typically includes ORACLE_HOME/bin
TNS_ADMIN:specify the location of the tnsnames.ora file
LD_LIBRARY_PATH:specify the path used to search for libraies on unix and linux ,not applicable to windows
SQLPATH:specify the location of SQL scripts


the SQL Buffer
the sql buffer sotres the most recently enterd SQL command or PL/SQL block,the command or blcok remains in the buffer until replaced by the next SQL command or PL/SL block,can view the buffer contents with the LIST command


can excute the command or block in the sql buffer using the RUN or / (slash) commands,the difference is RUN display the command or block in the buffer before excuting it,/ without displaying it first
you can use SAVE command to save the contents in the SQL buffer into a file