Summary ORACLE

ORACLE

Oracle: - Oracle is a RDBMS Package.
RDBMS=Relational Database Management System.
Oracle is used for entering data and developing new
business packages.
Oracle can be divided into three parts.
1. SQL * PLUS
2. PLSQL
3. PL/SQL
a. Developer 2000 (Forms)

SQL: - SQL Stands for Structure Query Language. sql is
a set of commands to used to access the data from
database. The SQL commands are three types.
1. Data Definition Language Commands (D.D.L)
2. Data Manipulation Language Commands (D.M.L)
3. Data Control Language Commands (D.C.L.)

Data Definition Language Commands (DDL): - These
commands are used for prepare the Databases (Tables),
define the Structure, Modify already defined structure,
and deleting Table. DDL is used for structuring the
database.
These commands are:
1. Create
2. Alter
3. Drop

Data Manipulation Language Commands (DML): -
These Commands are used for structure records from a
database working with database files appending records,
deleting records and updating records.

, 4. Delete

Data Control Language Commands (D.C.L): - These
commands are controls how have access to what table that
can log on the oracle system. Saves the Data in Oracle
Server when your interchange to one user to another user.
These Commands are:
1. Commit
2. Rollback
3. Arrant
4. Revoke
Starting Oracle Package: -
First Activate the Oracle Database Server:
Start Button --- Programs ---- Personal Oracle for
Windows 95 --- Start Database
After Running Oracle Package:
Start Button --- Programs ---- Oracle for Windows
95 --- SQL Plus 3.3
OR
Start Button --- Programs ---- Oracle --- SQL Plus
3.1
After Enter Oracle User Name and Password:
USER NAME : SCOTT
PASSWORD : TIGER
---- Ok
When you given on user name and password it can returns
the oracle SQL prompt.
SQL prompt indicates that oracle database server is ready
to entering of data.
Note: Each Oracle Query end with Semicolon (;).
SQL * PLUS: -
CL SCR;: - This command is used to Clear the Oracle
Screen.

,If you want Exit the Oracle Database Server: -
Syntax: -
SQL>Quit <Enter>
Click the Right mouse button over the Database Server
Icon on Taskbar here select the
--- Shutdown
If you want see the All Databases or Table in Your Oracle
Server: -
Syntax: -
SQL>Select * from Tab;
SQL * Plus Data Types: -
Data Type Oracle Data Type
Character Type Char
,, Varchar
,, Varchar2
,, long

Char(): - This Keyword is used to accessing the character
type of data into a specified Database file. This Data type
capacity is 255 letters.

Varchar(): - This Keyword is used to accessing the
character type of data into a specified Database file. This
Data type capacity is 2000 letters. But it cannot remove
the empty places when fill the data in variable.

Varchar2(): - This Keyword is used to accessing the
character type of data into a specified Database file. This
Data type capacity is 2000 letters. But it can remove the
empty places when fill the data in variable.

Long: - It is used for accessing the character type of data
into a specified Database file. This Data type capacity is

, Number: - The Data type is used to store the number type
of Data.

Data: - The Data type is used to store the Date type of
data.

Creating New Table in Oracle: -
Syntax: -
SQL> Create Table <Table_Name> (C_Data1
Char(10), C_Data2 Varchar(10), C_Data3
Varchar2(10), C_Data4 Long, N_Data Number,
D_Data Date);
Ex: -
SQL>
If you want see the Table Structure: -
Syntax: -
SQL>Describe <Table_Name>;
OR
SQL>Desc <Table_Name>;
Ex: -
SQL>Desc emp;

INSERT: - Inserts the New Records or Append the
Records into specified Table.
Syntax: -
INSERT INTO <Table_Name> (CF_Data, NF_Data,
DF_Data) Values (‘C_Value’,N_Value, ‘DD-MMM-
YY’);
Ex: -
Insert into course (sname, fname, course, fee) values
(‘Raja’,’Kiran’,’COA’,’12-APR-91’,1200);


Inserting Records with Second Method: -