![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle宝典
文章平均质量分 72
Haoge_90
这个作者很懒,什么都没留下…
展开
-
Oracle宝典--常用SQL
体系结构--等待事件(当前)select t.event, count(*) count from v$session t group by event order by count desc;--等待事件(历史汇集)select t.event, t.total_waits from v$system_event t order by total_waits desc;原创 2014-05-18 11:23:33 · 863 阅读 · 0 评论 -
Oracle宝典--编码规范
SQL编写规范单条SQL的长度不宜超过100行SQL子查询嵌套不宜超过3层SQL表关联需要考虑连接和限制条件的索引尽量避免HINT在代码中出现123456789select t.sql_text, t.sql_id, t.service原创 2014-05-17 20:54:03 · 905 阅读 · 0 评论 -
Oracle宝典--设计规范
表设计原则原创 2014-05-17 21:36:23 · 664 阅读 · 0 评论 -
Oracle宝典--dbms_output
dbms_output输出限制declare i number :=1;begin loop dbms_output.put_line(i); i := i+1; exit when i > 1000; end loop;end; ORA-20000: ORU-10027: buffer ov原创 2014-05-21 10:15:06 · 781 阅读 · 0 评论 -
Oracle宝典--Oracle关键字
Oracle关键字SQL> help reserved words; RESERVED WORDS (PL/SQL) ----------------------- PL/SQL Reserved Words have special meaning in PL/SQL, and may not be used for identifier names (unless原创 2014-05-21 09:15:02 · 735 阅读 · 0 评论