![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Scripts
Teresa7
这个作者很懒,什么都没留下…
展开
-
show_space
create or replace procedure show_space ( p_segname in varchar2, p_owner in varchar2 default user, p_type in varchar2 default ‘TABLE’, p_partition in varchar2 default NULL ) – t原创 2017-01-02 22:35:30 · 312 阅读 · 0 评论 -
查找一张表索引大于5
select b.owner, b.table_name, index_name,cnt, UNIQUENESS from all_indexes inner join (select owner, table_name, count(*) cnt from all_indexes group by owner, table_name原创 2017-05-10 17:43:05 · 775 阅读 · 0 评论 -
触发器Trigger
非工作日不能对EMP表进行删除、更新操作,使用触发器create or replace trigger tri_empbefore delete or update or insert on empbeginif to_char(sysdate, 'DY', 'nls_date_language = AMERICAN') in('SAT', 'SUN') thenraise_applic原创 2017-06-19 14:12:04 · 296 阅读 · 0 评论