Scribd
Upload
6 views2 pages

SQL

ORACLE primarily uses two types of database languages: SQL (Structured Query Language) and PL/SQL (Procedural Language extension of SQL). SQL is a non-procedural language that allows users to access and manipulate databases, while PL/SQL is procedural. SQL can perform various operations such as querying, retrieving, inserting, updating, and deleting records, as well as creating databases, tables, stored procedures, and views.

Uploaded by

SATYA
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views2 pages

SQL

ORACLE primarily uses two types of database languages: SQL (Structured Query Language) and PL/SQL (Procedural Language extension of SQL). SQL is a non-procedural language that allows users to access and manipulate databases, while PL/SQL is procedural. SQL can perform various operations such as querying, retrieving, inserting, updating, and deleting records, as well as creating databases, tables, stored procedures, and views.

Uploaded by

SATYA
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

There are mainly two different types of database language is ORACLE.

They are:

1) SQL (STRUCTURED QUERY LANGUAGE)

2) PL/SQL (PROCEDURAL LANGUAGE extension of SQL)

3) Dynamic SQL.(optional)

ORACLE is a Relational Database product which is used to store data permanently in

secondary storage devices. If you want to operate ORACLE then we are using following

languages:

1) SQL: It is non-procedural language.

2) PL/SQL: It is a procedural language.


What is SQL?
• SQL stands for Structured Query Language
• SQL lets you access and manipulate databases
• SQL became a standard of the American National Standards Institute
(ANSI) in 1986, and of the International Organization for
Standardization (ISO) in 1987

What Can SQL do?


• SQL can execute queries against a database
• SQL can retrieve data from a database
• SQL can insert records in a database
• SQL can update records in a database
• SQL can delete records from a database
• SQL can create new databases
• SQL can create new tables in a database
• SQL can create stored procedures in a database
• SQL can create views in a database
• SQL can set permissions on tables, procedures, and views

You might also like