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;

----------------------------------------------------------------------

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jun 06 21:15:42 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.