Home » SQL & PL/SQL » SQL & PL/SQL » Integer/NUmeric
Integer/NUmeric [message #20904] Fri, 28 June 2002 07:47 Go to next message
Inês Mendes
Messages: 2
Registered: June 2002
Junior Member
Hello!

In PL/SQL, How can I know if a variable is a number or not?

EX:
declare
v_ex varchar2

begin
IF v_ex IS NUMBER (???????) THEN
....
end if;
end;

tks

Report message to a moderator

Re: Integer/NUmeric [message #20906 is a reply to message #20904] Sat, 29 June 2002 23:46 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
please followup on our similiar discussion at

is there a function, property of any kind to see if the field is returning only numbers?

Report message to a moderator

Previous Topic: Matching colums of two tables in oracle
Next Topic: Error-20000
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 22:19:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.