摘要:
declare v_count NUMBER;begin select count(*) into v_count from emp; dbms_output.put_line('sql%rowcount =' || sql%rowcount);end;/declareb... 阅读全文
posted @ 2015-02-27 23:37
想想宝宝
阅读(271)
评论(0)
推荐(0)
摘要:
集合函数;declare type list_nested is table of varchar2(100) not null; v_all list_nested := list_nested('changan','hubei','shanghai','beijin... 阅读全文
posted @ 2015-02-27 17:53
想想宝宝
阅读(589)
评论(0)
推荐(0)
摘要:
--取出集合;长度declare type list_nested is table of varchar2(50) not null; v_all list_nested := list_nested('a','b','c','d','c','d');begin ... 阅读全文
posted @ 2015-02-27 13:40
想想宝宝
阅读(447)
评论(0)
推荐(0)