摘要:
declare v_count number(10); t_count number(10) default 0; cursor t_cur is select table_name from user_tables;begin for t_rec in t_cur loop execute imm 阅读全文
摘要:
declarev_table varchar2(60);v_num number;v_sum number;beginv_sum:=0;for idx in (select * from user_tables order by table_name) loopv_table:=idx.table_ 阅读全文
摘要:
1、创建DIRECTORYcreate directory dir_dp as 'c:/Oracle/dir_dp'; 2、授权Grant read,write on directory dir_dp to kaifeng_tysl_0401;--查看目录及权限SELECT privilege, d 阅读全文