--SQLPLUS Commands 

win + R
cmd

sqlplus user_name/password

sqlplus
Enter user name :
Enter Password  :

SHOW user

SQL> connect system/sys
Connected.

SQL> show user
USER is "SYSTEM"

SQL> conn hr/opn
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.

SQL> show user
USER is ""
--clear screen | cl scr

-- SELECT & ENTER -> copy
-- right click -> Paste 

SELECT * FROM departments;

/ -> Used to Execute Previous Query

SET LINESIZE 180		|   max 2000 | SET LINES 1200
SET PAGESIZE 30         |   SET PAGESIZE 0

&
&&

--&
SQL> SELECT &a+&b FROM dual;
Enter value for a: 10
Enter value for b: 20
old   1: SELECT &a+&b FROM dual
new   1: SELECT 10+20 FROM dual

     10+20
----------
        30
		
SQL> SET VERIFY OFF

SQL> SELECT employee_id, first_name, hire_date, salary, department_id
  2  FROM employees
  3  WHERE department_id = &did;

--  3  WHERE first_name = '&name';

SQL> SELECT &&i+&j FROM dual;
Enter value for i: 10
Enter value for j: 20

     10+20
----------
        30

SQL> /
Enter value for j: 23

     10+23
----------
        33
		
		
DEFINE i=10
SELECY &i+&j FROM dual;
UNDEFINE i;	


SQL> TTITLE dep_records;
SQL> BTITLE EOP

SQL> TTITLE OFF	
SQL> BTITLE OFF		

EDIT  | ED       (; not required | / will be there in end | save the file ) / to execute 

@"D:\Oracle\Script.sql"

SET TIMING ON   | OFF
SET FEEDBACK ON | OFF
SET HEADING ON  | OFF


--Explain plan
SET AUTOT ON
SET AUTOT OFF

SQL> SPOOL "D:\Scripts\session_log.sql"


SQL> SPOOL OFF


SQL> SET HEADING OFF
SQL> SET AUTOT OFF
SQL> SET FEEDBACK OFF
SQL> SET TIMING OFF
SQL> SET PAGESIZE 0


HELP SPOOL
HELP index 

col salary FOR 99,999.99$
COL first_name FOR a 10

LIST | L

EXIT