SQL CONCEPTS:-
Hello Friends,
Before Starting with Oracle Apps we will brush up some SQL & PL/SQL concepts.
Today we will discuss SQL basics.
 |
| Learn SQL Concepts |
Structured Query Language(SQL) is the standard language designed to access
relational databases. SQL is pronounced either as the word Sequel or as the letters SQL.
SQL uses simple syntax that is easy to learn and use there are five types of SQL
statements given below.
Query Statements: Allow you to retrieve the rows stored in the database tables. You
write a query using the SQL SELECT statement.
Data Manipulation Language (DML) Statements: Allows you to modify the contents
of the tables. There are three DML statements.
_ INSERT - Allows you to Insert row(s) into the Table.
_ UPDATE - Allows you to change a Row.
_ DELETE - Allows you delete the rows from the Table.
Data Definition Language (DDL): Allows you to define the Data structures, such as
tables that make up a database. There are five basic types of DDL statements.
_ CREATE – Allows you to Create Database structure.
Ex: Create Table – Used to create a Table in the Database.
Create User – Used to create the database user.
_ ALTER – Allows you to modify a database structure.
_ DROP – Allows you to remove a database structure.
_ RENAME – Allows you to change the name of the table.
_ TRUNCATE – Allows you to delete the entire contents of the table.
Transaction Control (TC) Statements: Allows you to permanently record the changes
made to rows stored in a table or undo the changes. There are three TC Statements.
_ COMMIT – Allows you to permanently record the changes made to the rows.
_ ROLLBACK – Allows you to undo the changes made to the rows.
_ SAVEPOINT – Allows you to set a SAVEPOINT to which you can rollback changes
you made.
Data Control Language (DCL): Allows you to change the permissions on the database
structures. There are two DCL statements.
_ GRANT – Allows you to give another user access to your database structures,
such as tables.
_ REVOKE – Allows you to prevent another user from accessing to your database
structures, such as tables.
