这是一个CSDN Oracle开发版块里，网友问过的一道题
题如下
create table A_TEST
(
PAYOUT_ITEM_CODE VARCHAR2(30) not
null,
FORMULA_DET VARCHAR2(1000)
)
create table B_TEST
(
ELEMENT_ID VARCHAR2(5) not null,
NAME VARCHAR2(41)
)
求写oracle多个字符替换（有测试数据）
insert into a_test (PAYOUT_ITEM_CODE, FORMULA_DET)
values
('30228', '({30015}+{30016})*450');
insert into a_test
(PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30102', '({30015}+{30016})*1500');
insert into a_test (PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30102',
'({30015}+{30016})*5000');
insert into a_test (PAYOUT_ITEM_CODE,
FORMULA_DET)
values ('30102', '({30015}+{30016})*2500');
insert into
a_test (PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30102',
'({30015}+{30016})*2300');
insert into a_test (PAYOUT_ITEM_CODE,
FORMULA_DET)
values ('30102', '({30015}+{30016})*1150');
insert into
a_test (PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30104',
'({30015}+{30016})*300*12');
insert into a_test (PAYOUT_ITEM_CODE,
FORMULA_DET)
values ('30226', '{30057}*2300');
insert into a_test
(PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30102', '({30015}+{30016})*5000');
insert into a_test (PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30102',
'({30015}+{30016})*3000');
insert into a_test (PAYOUT_ITEM_CODE,
FORMULA_DET)
values ('30102', '({30015}+{30016})*1500');
insert into
a_test (PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30226',
'{30006}+{30061}+{30008}');
insert into a_test (PAYOUT_ITEM_CODE,
FORMULA_DET)
values ('30226', '{30057}*3800*12');
insert into a_test
(PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30210',
'({30030}+{30031}+{30032})*38000+{30033}*23000');
insert into a_test
(PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30210',
'({30030}+{30031}+{30032}+{30033})*38000+{30036}*10000');
insert into
a_test (PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30229',
'({30015}+{30016})*1400');
insert into a_test (PAYOUT_ITEM_CODE,
使用PL/SQL developer远程访问oracle数据库时，首先要确定本机中装有oracle客户端。目前还不知道哪里单独的oracle客户端安装包。（因为我用的是oracle10g，oracle10g安装的过程中没有特定的客户端选项，所以我一般都是在本机用安装oracle所有功能）
在本机安装好oracle客户端后，我们在本机(即客户端)的oracle的安装目录下 ......
