展开全部
1、编写函数,636f70793231313335323631343130323136353331333433623063sp_put_num_2;内容为:
create or replace procedure sp_put_num_2(in_num varchar2,
out_num_1 out varchar2,
out_num_2 out varchar2,
out_info out varchar2) as
n_num number;
begin
begin
n_num := to_number(in_num);
out_num_1 := trunc(n_num);
out_num_2 := case when instr(in_num, '.') > 0 then substr(in_num, instr(in_num, '.') + 1) end;
out_info := '转换成功';
exception
when others then
out_info := '非数值类型';
end;
end;
2、函数进行编译;
3、进行函数多场景测试,如输入为字符串类,则返回错误信息‘非数值类型’;
4、输入为数字型,如'123.25',再次测试,分别返回整数、小数部分;