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 =‘’;
oracle 视图 序列 同义词
最新推荐文章于 2022-04-24 22:54:55 发布