- 博客(9)
- 资源 (1)
- 问答 (3)
- 收藏
- 关注
原创 jmx监控tomcat
下面的请求可以获得所有jmx监控的信息http://localhost:8080/manager/jmxproxy/?qry=
2015-07-30 21:13:19 613
原创 plsql中异常的传递
begin declare v_name varchar2(2) := 'ABC'; begin dbms_output.put_line(v_name); exception when others then dbms_output.put_line('xxx'); end;exception when others
2015-07-06 19:15:36 606
原创 plsql异常之exception_init
常用异常处理declare e_duplicate_name exception; v_ename emp.ename%type; e_newname emp.ename%type := 'smith';begin select ename into v_ename from emp where empno = 7639; if v_ename = v_n
2015-07-06 15:49:25 1242
原创 oracle分析函数使用
select o.deptno, o.job, sum(o.sal), rank() over(order by sum(o.sal) desc), dense_rank() over(order by sum(o.sal) desc), row_number() over(partition by o.deptno
2015-07-06 14:15:57 521
原创 oracle coalesce函数
该函数返回表达式中的第一个非空表达式select coalesce(subobject_name,object_type) from t_objects where object_name='ICOL$';
2015-07-05 11:10:11 633
原创 sum over的用法
SQL> select * from t; ID1 ID2---------- ---------- 1 2 2 3 3 6 4 7SQL> select t1.id1,t2.id1,sum(t
2015-07-03 16:14:59 809
原创 plsql中的集合
集合有3种类型:1索引表2嵌套表3变长数组语法:type type_name as table of element_type [not null] index by [pls_integer|binary_integer|varchar2(size)]type deptno is table of dept.deptno%type not null index by pls_intege
2015-07-03 15:21:57 536
原创 plsql中的循环
来自pl/sql开发入门loop与exit的示例declare v_count number(2) := 0;begin loop v_count := v_count + 1; dbms_output.put_line('行' || v_count); if v_count = 10 then exit; end
2015-07-03 11:30:00 684
原创 plsql中的子类型
子类型就是在标准类型上加些限制生成的一种新类型。declare subtype empcounttype is integer;empcount empcounttype;beginselect count(*) into empcount from emp;dbms_output.put_line(empcount);end;子类型定义示例declaret
2015-07-03 11:11:42 514
TA创建的收藏夹 TA关注的收藏夹
TA关注的人