28 July 2000
 
                Starting SQLPLUS and logging on
                -------------------------------
 
 The following oracle specific environment variables have
 to be added to your .profile if you have not already added.
 
       TERM=vt100
       ORACLE_TERM=vt100
       ORACLE_HOME=/oracle
       ORACLE_SID=GEN
       PATH= $ORACLE_HOME/bin:/usr/ccs/bin:$PATH
       export PATH TERM ORACLE_TERM ORACLE_HOME ORACLE_SID
 
 Invoke sqlplus as follows
 
       $ sqlplus
 
 Again enter your oracle username and password at the respective
 prompts and press Enter key. 
 

Your password is same as your login name. Change your password by giving
following command

	SQL> password; 

 SQL*Plus displays the version of ORACLE to which you connected and the
 versions of available tools . Then it displays the SQLPlus command
 prompt as follows.
 
   SQL>
 
 
 			Introduction to SQLPLUS
 			-----------------------
 

Creating tables :
-----------------

create table students ( rollno character(8), name varchar(30), hostel
integer, cpi number(3,2) );

Insert/delete/update data :
--------------------------

   SQL> Insert into students values ( '99305018', 'xyz', 11, 9.23);

   SQL> update students set cpi = 9.46 where rollno = '99305018';

   SQL> delete students where srollno = '99305018';


Running queries :
-----------------

   SQL> select * from students;
   SQL> select rollno from students;


Runnings batch of queries :
-------------------------

- Create a file having extension as .sql.
- Write quries in the file. Queries should with a semicolon
- Execute 
      SQL> start <filename>

Getting help :
------------

SQL> help [topic]

Listing all the tables :
-----------------------

SQL> select * from cat;

For saving output in a file :
---------------------------

	SQL> SPOOL filename

Output of any command after this will be stored in the "filename".lst