摘要: SELECT DISTINCT(TABLESPACE_NAME) FROM ALL_TABLES; SELECT COUNT(*) FROM ALL_TABLES where TABLESPACE_NAME='XX'; COUNT(*) 383 SELECT DISTINCT(OWNER) FROM ALL_VIEWS; SELECT COUNT(*) FROM ALL_VIEWS WHERE O 阅读全文
posted @ 2019-11-14 16:59 kakaisgood 阅读(128) 评论(0) 推荐(0)
摘要: update all line start with -- to space 阅读全文
posted @ 2019-11-14 16:35 kakaisgood 阅读(108) 评论(0) 推荐(0)
摘要: 阅读全文
posted @ 2019-11-14 11:54 kakaisgood 阅读(147) 评论(0) 推荐(0)