oracle 视图 序列 同义词

CREATE OR REPLACE VIEW myview
AS
SELECT * FROM books where price>50
WITH CHECK OPTION
/

CREATE OR REPLACE MYVIEW
AS
SELECT * FROM STUDENT  WHERE SCORE>=50
WITH READY ONLY
/


DESC DBA_VIEWS
DESC ALL_VIEWS
desc user_views;当前用户的


select text from user_views where view_name='V_read'
; 看VIEW的SQL语句

ORACLE 同义词

DESC DBA_synonyms;

desc dba_synonyms;

序列

 select sequence_name,sequence_owner from dba_sequences where sequence_owner =‘’;