Oracle DDL DML Collection

1.DBMS_OUTPUT

DECLARE
   strdate   VARCHAR2 (20);
BEGIN
   strdate := SYSDATE ();           --动态执行DDL语句
   DBMS_OUTPUT.put_line (strdate);  --PL/SQL print
EXCEPTION
   WHEN OTHERS
   THEN
      BEGIN
         NULL;
      END;
END;

2.Alter table

alter table dcnefrm add (Dsource VARCHAR2(10)  default(' ') not null );

3.Create table

关键字(primary key)必须是非空,表中记录的唯一性
not null 非空约束
Default 缺省值约束
check 检查约束, 使列的值符合一定的标准范围
unqiue 唯一性约束
foreign key 外部键约束

CREATE TABLE employee
        (empno NUMBER(10) PRIMARY KEY,
        NAME VARCHAR2(40) NOT NULL,
        deptno NUMBER(2) DEFAULT(10) NOT NULL,
        salary NUMBER(7,2) CHECK (salary<10000),
        birth_date DATE,
        soc_see_num CHAR(9) UNIQUE,
        FOREIGN KEY(deptno) REFERENCES dept.deptno)
    TABLESPACE users;