Oracal SQL *Plus

Orcal:
Oracal consists of a comprehensive set of application building and end user product aimed at providing complete information technology  solution.

Oracal application are portable across a  wide range of platforms and OS, from personal computer to large parallel  processor.
Oracle is a case sensitive language. If you write in lower case so all lower case. If you write in upper case so all upper case. You have no permission  to use both upper cases and lower case;


SQL>set pagesize 2000;                        //for adjust page size
SQL>set linesize 3000;                        //for adjust line size
SQL>select * from tab;                       //tab mean table
SQL>select * from emp;                   //
SQL>desc dept;                               //desc mean describe
SQL>ed;                                        //for edit


SQL stands for  Structure Query Language.

Command	Description
select Insert update delete	The select is the most commonly used command. It is used to retrieve data from the database. Insert,update,delete are used to enter new rows,changes existing rows and remove unwanted rows from tables in the database respectively.  DML: They are some time collectively known as DML (Data Manipulation Language)
create alter drop rename	These 3 commands are used dynamically to set-up, change and remove any data structure.  DDL: They are sometimes known as DDL(Data Definition Language).
grant revoke	These two commands are used to give or remove access rights to both the ORACAl database and the structure within it. DCL: Sometimes it is known as DCL(Data Control Language)

*select all chat;
SQL>select empno ename,job sal from emp;;