1.字段描述无法显示
cmd---regedit
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0
将NLS_LANG值改成SIMPLIFIED CHINESE_CHINA.ZHS32GB18030
2.SQL查询语句动态参数输入符号&name;
3.将空值转化为0的函数: nvl(sum(t.apl_amount_n) ,0)into n_rmmc_add_amount_n 。
4.ORACLE异常处理一定要放在begin ...end之间,如下:
(1)
begin
exception --异常
when others then
v_errcode := sqlcode;
v_errmsg := substr(sqlerrm,1,100);
dbms_output.put_line('error code is' || v_errcode || ' error message is' || v_errmsg);
rollback;
end;
when others then
v_errcode := sqlcode;
v_errmsg := substr(sqlerrm,1,100);
dbms_output.put_line('error code is' || v_errcode || ' error message is' || v_errmsg);
rollback;
end;
(2)
begin
select c.rmmc_end_balance_n into n_rmmc_begin_balance_n from mypay_report_mol_merc_c2cc
select c.rmmc_end_balance_n into n_rmmc_begin_balance_n from mypay_report_mol_merc_c2cc
exception when no_data_found then
n_rmmc_begin_balance_n :=0;
end;
n_rmmc_begin_balance_n :=0;
end;
5.用户表,索引,主键等查询方式:
select * from user_tables;
select * from user_indexes where uniqueness = 'NONUNIQUE';
select * from user_indexes where uniqueness = 'UNIQUE';
select * from all_constraints a where a.r_owner = 'MYPAY';
select * from user_indexes where uniqueness = 'NONUNIQUE';
select * from user_indexes where uniqueness = 'UNIQUE';
select * from all_constraints a where a.r_owner = 'MYPAY';