摘要： 一、SYNONYM 1.CREATE CREATE SYNONYM dept FOR SCOTT.dept; 2.DROP DROP SYNONYM dept; 3.CREATE PUBLIC SYNONYM CREATE PUBLIC SYNONYM dept FOR SCOTT.dept 4.DISPLAY SYNONYM DESC DBA_SYNONYMS; DE... 阅读全文

摘要： 1.CREATE ORACLE VIEW CREATE OR REPLACE VIEW myview AS SELECT * FROM books WHERE price>30 WITH CHECK OPTION --When INSERT DATA THROUGH VIEW,If the DATA IS NOT ... 阅读全文