本文共 1854 字，大约阅读时间需要 6 分钟。

??????????

Oracle ???????

??????? Oracle ????????????????????????????????PL/SQL ????????

???????

CREATE TABLESPACE SYPRO_201310 DATAFILE 'F:\ORACLE_11G\oradata\orcl\SYPRO_201310.DBF' SIZE 10M AUTOEXTEND ON

2. ?????

DROP TABLESPACE SYPRO_201310 INCLUDING CONTENTS AND DATAFILES

3. ???????

SELECT * FROM DBA_TABLESPACES

4. ??????????

CREATE USER liutao IDENTIFIED BY liutao DEFAULT TABLESPACE SYPRO_201310 TEMPORARY TABLESPACE TEMP

5. ??????

GRANT CONNECT TO LIUTAO WITH ADMIN OPTIONGRANT DBA TO LIUTAO WITH ADMIN OPTION

---

?????

6. ??????

   • ????

   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

7. ????

   COMMENT ON TABLE TB_STUDNET IS '?????'

   COMMENT ON COLUMN TB_STUDENT.EMAIL IS '??????'

8. ????

   DROP TABLE TB_STUDNET

   DROP TABLE TB_STUDNET Purge

---

???????

9. ????

   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)

10. ????

    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

---

??????

11. ???????

    ALTER USER SCOTT ACCOUNT UNLOCK

    ALTER USER SCOTT IDENTIFIED BY TIGER

12. ????

    DROP USER LIUTAO

    REVOKE CONNECT FROM LIUTAO

---

??PL/SQL ??

13. ???????

    DECLARE    STR VARCHAR2(50):='HELLOWORD' ;BEGIN    STR:=STR || 'LIUTAO' ;    dbms_output.put_line(STR) ;EXCEPTION    WHEN OTHERS THEN        dbms_output.put_line('