Codes & Concepts

SQL*Plus

SQL*Plus is an interactive OOTB query tool that is installed with every Oracle Database Server or Client installation. It has a command-line user interface, a Windows Graphical User Interface (GUI) and the  iSQL*Plus web-based user interface



Guidelines before you can run SQL*Plus ?

• Install Oracle Database (or Oracle Client for the command-line SQL*Plus). 
• Obtain an Oracle Database login username and password during installation or from your Database Administrator. 
• Ensure a sample database is installed and that you have a login username and password for it during Oracle Database installation.
• Create a default database during installation or obtain the connection identifier for the Oracle Database 
• Ensure the database you want to connect to is started or OPEN mode. 

End user can use this interactive tool to connect to database schema directly. Below are the instructions to connect to oracle database using SQL*Plus client 
 

• Set below OS environment variable to invoke/connect Sqlplus

• ORACLE_HOME : Oracle Installation home (/u01/app/oracle/product/11.2.0/dbhome_1)
• PATH: Set PATH Variable to$ORACLE_HOME/bin:$PATH
• ORACLE_SID: Global DB name or unique DB identifier
• LD_LIBRARY_PATH: Set to $ORACLE_HOME/lib

•  Invoke Sqlplus client
•  Enter the SQL*Plus command in the form: (for sysdba DB Schema) 
• sqlplus username/password as sysdba
• Enter the SQL*Plus command in the form: (for non-sysdba DB Schema)  
• sqlplus username/password

Sample:
SQL*Plus: Release 11.2.0.3.0
Copyright (c) 2012, Oracle

Connected to:
Oracle11g Enterprise Edition Release