oracle语法（oracle语法）.docVIP

oracle语法（oracle语法） Basic concepts DDL data definition language - building database objects Create /alter/ drop/ truncate DML data manipulation language - data view and maintenance Select / insert /delete /update TCL transaction control language - whether data is saved to the database Commit / rollback / savepoint DCL data control language -- view the permissions of objects Grant / revoke Database design Composition of relational data model One or more sheets Table index view trigger The relation between table and table Database Schema Conceptually: a group of DDL Physical: a namespace that con