Oracle Cloud Database

 

Oracle Cloud Database

 

Today we are going to learn about oracle database.

First question is, what is oracle database?

Then we are going to know, what is SQL query?

After that we discussed about, how many types of queries are?

 

 

What is Oracle Database?

Oracle word means who do the prophecy. Oracle Company is always work for future. Oracle is used worldwide in different organizations.

Oracle is software that efficiently organizes data in a relational manner. Oracle Databases are very efficient to keep data back, maintaining or restoration of data is done by oracle database.  

 

What is SQL query?

SQL Stand for Structure Query Language. It is used to managing data held in relational database management system. 

Select Query has Three Parts

First part of query called Select, second part called From and third part is called Where

 

Select	From	Where
*  “All attributes select” Name, Emp_id, etc “ Or other Attributes Of Table”	“After the from table name will come” Emaple: Student, Employees, Department etc…	In query after the where condition applying Example: <, >, min, max, count, sum etc…

 

How many types of queries are?

SQL Queries or commands are divided into five Categories:

Data Definition Language (DDL).

·        Create

·        Alter

·        Drop

·        Truncate

·        Comment

 

Data Manipulation Language (DML) & Data Query Language (DL).

·        Select

·        Insert

·        Update

·        Delete

·        Merge

·        Call

·        Explain Plain

·        Lock Table

 

Data Control Language (DCL).

·        Grant

·        Revoke

 

Transaction Control Statement (TCS).

·        Commit

·        Savepoint

·        Rollback

·        Set Transection

 

Session Control Statement (SCS) OR Data Administration Language (DAL). 

·        Start Audit  

·        Stop Audit