1. Data Definition Language (DDL).These commands are auto commit.
2. Data Manipulation Language (DML).
3. Transaction Control Language (TCL).
4. Data Control Language (DCL).
DDL( DR CAT) | DML (SUDI) | TCL (CRS) | DCL (GR) |
1.DROP | 1.SELECT | 1.COMMIT | 1.GRANT |
2.RENAME | 2.UPDATE | 2.ROLLBACK | 2.RENAME |
3.CREATE | 3.DELETE | 3.SAVEPOINT | |
4.ALTER | 4.INSERT | ||
5.TRUNCATE |
There are 10 types Database Objects in Oracle
6 in SQL and 4 in PL/SQL
6 Sql Database Object
1.TABLE
2.VIEWS
3.SYNONYMS
4.SEQUENCE
5.INDEX
6.CLUSTER
4 DATABASE OBJECT IN PL/SQL
1.FUNCTION
2.PROCEDURE
3.PACKAGE
4.TRIGGER
No comments:
Post a Comment