Home » SQL & PL/SQL » SQL & PL/SQL » Re: HOW to cpnvert varchar2 to NUMBER?
Re: HOW to cpnvert varchar2 to NUMBER? [message #35619] Mon, 01 October 2001 15:16
oraboy
Messages: 97
Registered: October 2001
Member
declare
lv_no number;
lv_str varchar2(100);
begin
lv_no = to_number(lv_str)/100;
dbms_output.put_line(to_char(lv_no));
end;

----------------------------------------------------------------------
Previous Topic: ORDSYS.ORDIMAGE
Next Topic: Null value maintenance
Goto Forum:
  


Current Time: Fri Mar 29 05:06:48 CDT 2024