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 Str...
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: -
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller THEEXCELLENCELIBRARY. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.49. You're not tied to anything after your purchase.
