26.oracleocp题库dba经典辅助学习les.pptxVIP

Using DDL Statementsto Create and Manage Tables ;Objectives;Database Objects;Naming Rules;You must have: CREATE TABLE privilege A storage area You specify: Table name Column name, column data type, and column size;Referencing Another User’s Tables;Specify a default value for a column during an insert. Literal values, expressions, or SQL functions are legal values. Another column’s name or a pseudocolumn are illegal values. The default data type must match the column data type.;Creating Tables;Data Types;Datetime Data Types;Datetime Data Types;Datetime Data Types;INTERVAL DAY TO SECOND Data Ty