create or replace procedure test
(
Dynamic in VARCHAR2,
Degree in VARCHAR2,
Fee in VARCHAR2,
Margin in VARCHAR2,
result out VARCHAR2 --返回结果
)
AsoutDynamic number(12,2);
jiage VARCHAR2(40);
outDegree VARCHAR2(40);
outFee number(12,2);
outMargin number(12,1);
FixedoutDynamic VARCHAR2(40);
FixedoutDegree VARCHAR2(40);
FixedoutFee VARCHAR2(40);
FixedoutMargin VARCHAR2(40);
FixedPercent VARCHAR2(40);
beginselect cast(Dynamic as number(10,2)) into result from dual;
select cast(Degree as number(18,2)) into outDegree from dual;
select cast(Fee as number(18,2)) into outFee from dual;
select cast(Margin as number(18,2)) into outMargin from dual;
--拼写返回数据串
result:=result||outDynamic||'~';
result:=result||FixedoutDegree||'';
result:=result||FixedoutFee||'';
result:=result||FixedoutMargin||'';
result:=result||FixedPercent||'';--异常情况处理 EXCEPTION
WHEN OTHERS THEN result := '1';
ROLLBACK; end test ;如上存储过程,各个依次输入的数据项为933803.0001;0.2587;0.00;241613.5070想要返回的结果为933803.00~26~0.00~241613.51。但目前返回的结果为933803~.26~0~241613.5。该如何修改??求救!!!
(
Dynamic in VARCHAR2,
Degree in VARCHAR2,
Fee in VARCHAR2,
Margin in VARCHAR2,
result out VARCHAR2 --返回结果
)
AsoutDynamic number(12,2);
jiage VARCHAR2(40);
outDegree VARCHAR2(40);
outFee number(12,2);
outMargin number(12,1);
FixedoutDynamic VARCHAR2(40);
FixedoutDegree VARCHAR2(40);
FixedoutFee VARCHAR2(40);
FixedoutMargin VARCHAR2(40);
FixedPercent VARCHAR2(40);
beginselect cast(Dynamic as number(10,2)) into result from dual;
select cast(Degree as number(18,2)) into outDegree from dual;
select cast(Fee as number(18,2)) into outFee from dual;
select cast(Margin as number(18,2)) into outMargin from dual;
--拼写返回数据串
result:=result||outDynamic||'~';
result:=result||FixedoutDegree||'';
result:=result||FixedoutFee||'';
result:=result||FixedoutMargin||'';
result:=result||FixedPercent||'';--异常情况处理 EXCEPTION
WHEN OTHERS THEN result := '1';
ROLLBACK; end test ;如上存储过程,各个依次输入的数据项为933803.0001;0.2587;0.00;241613.5070想要返回的结果为933803.00~26~0.00~241613.51。但目前返回的结果为933803~.26~0~241613.5。该如何修改??求救!!!
解决方案 »
- 困扰我很久的statspack问题
- 64 位 windows server 2008 上需要安装什么才能使 ASP 连接上 Orcale 数据库服务器
- 急!两oracle字符集不一致如何实现信息互访
- 困扰几天了:在本地的tnsnames.ora文件里面,配置了一个本地命名,可偏偏就是报:无法处理服务名?求救
- 对象类型初始化问题
- 爲啥不能上网?
- ORACLE的sql plus 查询结果存入一个文件的问题?急!!!
- 求ID为03的记录号SQL语句或函数怎样写?
- oracle 怎么登陆到 Enterprise manager consol
- oracle imp 导入错误
- 求教一条SQL语句,按时间段统计
- oracle中按小数点截取数据串
select trim(to_char(Dynamic ,'999999990.00')) into result from dual;
select trim(to_char(Degree ,'999999990.00')) into outDegree from dual;
select trim(to_char(Fee ,'999999990.00')) into outFee from dual;
select trim(to_char(Margin ,'999999990.00')) into outMargin from dual;如果数值很大的话可以修改to_char中的格式