Basics of SQL
Widely Discuss about the structured query language and SQL * plus. In this session we define about how to logging in to SQL * plus and how to function the commands.In SQL we have various command categories every categories have variant type of commands. We study all these commands and we also learn about the data kinds of oracle.
-SQL is a Structured Query Language used for all RDBMS.
-SQL * Plus is a tool that is used to work with and the commands are executed.
-SQL* Plus statements are not saved in the buffer.
-DDL – Data Definition Language that describe the structure of an object
-They are TRUNCATE, CREATE, DROP, ALTER, RENAME
-DML – Data Manipulation Language which is used to Insert, Delete and Update records.
-INSERT, DELETE and UPDATE commands are known as DML commands
-TCL – Controls the Transactions. It stands for Transaction Control Language
-They are ROLLBACK, COMMIT and SAVEPOINT.