ORACLE
Oracle: - Oracle is a RDBMS Package.
RDBMS=Relational Database Management System.
Oracle is used for entering data and developing new
... [Show More] 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.
These commands are:
1. Select
2. Insert
3. Update
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.
Syntax:
SQL> CL SCR;
If you want Exit the Oracle Database Server: -
Syntax: -
SQL>Quit
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 65535 letters.
Note: The above Data types are must be mentioning the Size of the Variable but this long variable not accept the size of the Variable.
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. [Show Less]