SQL Statements
Oracle SQL complies with industry-accepted standards. Oracle Corporation ensures future
compliance with evolving standards by actively involving key personnel in SQL standards
committees. Industry-accepted committees are the American National Standards Institute (ANSI)and the International Standards Organization (ISO). Both ANSI and ISO have accepted SQL as the standard language for relational databases.
Statement Description
- SELECT Retrieves data from the database
- INSERT,UPDATE,DELETE,MERGE
Enters new rows, changes existing rows, and removes unwanted rows
from tables in the database, respectively. Collectively known as data
manipulation language (DML).
- CREATE,ALTER,DROP,RENAME,TRUNCATE
Sets up, changes, and removes data structures from tables. Collectively
known as data definition language (DDL).
- COMMIT,ROLLBACK,SAVEPOINT
Manages the changes made by DML statements. Changes to the data can
be grouped together into logical transactions.
- GRANT,REVOKE
Gives or removes access rights to both the Oracle database and the
structures within it. Collectively known as data control language
(DCL).
Yes I agree that this language is universally accepted to operate relational databases. Its is not only interesting but also easy to understand too. You do have shared all the statements with their usage that helps to manage the database. Thanks a lot for this informative post.
ReplyDeleteoracle ebs r12