Structured Query Language(SQL)

SQL is the language which is used to interact with a database management system. All programs and users can have the power of accessing data in an oracle database by SQL. By Structured Query Language(SQL) you can query data, insert, update and delete rows in a table. You can create, replace, alter and drop objects by QSL statement. You can also gain the power of accessing the database and its objects by SQL statements.


Look at the following table and it will help you understand the SQL statements
and its functions in oracle database.

SQL Statement	Functions
Select	Retrieves data from database
insert, update, rollback(delete)	inserts data, updates and deletes data in database
create, alter, drop	creates new tables in database, alter existing tables, deletes tables from database
commit	save data permanently in database.