摘要:
set serveroutput on declare v_ret sys_refcursor; type typ_row is record ( col_1 varchar2(100),col_2 number ,col_3 number, col_4 number ,col_5 number, 阅读全文
摘要:
select table_name from ALL_TABLES where OWNER='PORTAL';select * from dba_tables where owner='PORTAL';--用户名要大写!select table_name from user_tables ; 阅读全文
摘要:
select * from lacom a where banktype='02' start with a.agentcom='0202081584' Connect by prior a.upagentcom=a.agentcom ; 递归调用的用法: select level,a.* from 阅读全文