本文共 1854 字，大约阅读时间需要 6 分钟。
??????????
??????? Oracle ????????????????????????????????PL/SQL ????????
CREATE TABLESPACE SYPRO_201310 DATAFILE 'F:\ORACLE_11G\oradata\orcl\SYPRO_201310.DBF' SIZE 10M AUTOEXTEND ON
DROP TABLESPACE SYPRO_201310 INCLUDING CONTENTS AND DATAFILES
SELECT * FROM DBA_TABLESPACES
CREATE USER liutao IDENTIFIED BY liutao DEFAULT TABLESPACE SYPRO_201310 TEMPORARY TABLESPACE TEMP
GRANT CONNECT TO LIUTAO WITH ADMIN OPTIONGRANT DBA TO LIUTAO WITH ADMIN OPTION
??????
CREATE TABLE TB_STUDENT_NEW AS SELECT * FROM TB_STUDENT_OLD WHERE 1 = 2
CREATE TABLE TB_STUDENT_NEW AS SELECT * FROM TB_STUDENT_OLD
ALTER TABLE TB_STUDENT ADD EMAIL VARCHAR2(50)
ALTER TABLE TB_STUDNET MODIFY EMAIL VARCHAR2(100)
ALTER TABLE TB_STUDNET DROP COLUMN EMAIL
ALTER TABLE TB_STUDNET RENAME COLUMN EMAIL TO EMAIL_163
RENAME TB_STUDNET TO TD_STUDNET
????
COMMENT ON TABLE TB_STUDNET IS '?????'
COMMENT ON COLUMN TB_STUDENT.EMAIL IS '??????'
????
DROP TABLE TB_STUDNET
DROP TABLE TB_STUDNET Purge
????
ALTER TABLE TB_STUDENT ADD CONSTRAINTS TB_STUDENT_ID_PK PRIMARY KEY ID
ALTER TABLE TB_STUDENT ADD CONSTRAINTS TB_STUDENT_EMAIL_UK UNIQUE EMAIL
ALTER TABLE TB_STUDENT ADD CONSTRAINTS TB_STUDENT_CLASS_ID_FK FOREIGN KEY (CLASS_ID) REFERENCES TB_CLASS (CLASS_ID)
????
ALTER TABLE TB_STUDENT DROP CONSTRAINTS TB_STUDENT_CLASS_ID_FK
ALTER TABLE TB_STUDENT DISABLE CONSTRAINTS TB_STUDENT_CLASS_ID_FK
ALTER TABLE TB_STUDENT ENABLE CONSTRAINTS TB_STUDENT_CLASS_ID_FK
???????
ALTER USER SCOTT ACCOUNT UNLOCK
ALTER USER SCOTT IDENTIFIED BY TIGER
????
DROP USER LIUTAO
REVOKE CONNECT FROM LIUTAO
DECLARE STR VARCHAR2(50):='HELLOWORD' ;BEGIN STR:=STR || 'LIUTAO' ; dbms_output.put_line(STR) ;EXCEPTION WHEN OTHERS THEN dbms_output.put_line('转载地址：http://vopfk.baihongyu.com/