- 博客(8)
- 收藏
- 关注
原创 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
778
原创 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
731
原创 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
原创 Oracle宝典--编码规范
SQL编写规范单条SQL的长度不宜超过100行SQL子查询嵌套不宜超过3层SQL表关联需要考虑连接和限制条件的索引尽量避免HINT在代码中出现123456789select t.sql_text, t.sql_id, t.service
2014-05-17 20:54:03
902
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人