摘要:
declare v_count NUMBER;begin select count(*) into v_count from emp; dbms_output.put_line('sql%rowcount =' || sql%rowcount);end;/declareb... 阅读全文
摘要:
集合函数;declare type list_nested is table of varchar2(100) not null; v_all list_nested := list_nested('changan','hubei','shanghai','beijin... 阅读全文
摘要:
--取出集合;长度declare type list_nested is table of varchar2(50) not null; v_all list_nested := list_nested('a','b','c','d','c','d');begin ... 阅读全文