数据库函数小技巧

declare
gorderno NUMBER(18,0);
gpayamt NUMBER(10,2);
gtimestamp NUMBER(18,0);
gpaycurrency VARCHAR2(10 BYTE);
gbankserial VARCHAR2(64 BYTE);
greturnid VARCHAR2(100 BYTE);
gtravelsky VARCHAR2(50 BYTE);
begin
gorderno:=7345234223412341;
select pay_amt into gpayamt from order_info where order_no=gorderno;
select time_stamp into gtimestamp from order_info where order_no=gorderno;
gpaycurrency:='CNY';
select to_char(sysdate,'yyyymmddhh24miss')||'0010' into gbankserial from dual;
greturnid:='LAPUTA_TEST';--改升支付为CHANGE_KTT
insert into pay_info （。。。。。。）values(。。。, sysdate, gpayamt, '20052', gtimestamp, gpaycurrency,gbankserial, gorderno, greturnid);
commit;
end;