| |
GeekInterview.com > Interview Questions > Oracle > Programmatic Constructs
| Print | |
Question: wht is the logic to find whether the entered input is a number or the character. How can we design this program using a procedure or the function
|
| April 04, 2007 04:26:07 |
#1 |
| Pulakesh Dey |
Member Since: Visitor Total Comments: N/A |
RE: wht is the logic to find whether the entered inpu...
|
The value will be given as parameter inside ascii() function
------------------------------------------------------------------------------
SELECT DECODE(COUNT(N),0,'CHARACTOR','NUMBER') FROM
(
SELECT 1 N FROM DUAL
WHERE ASCII('A') BETWEEN 48 AND 57
)
WHERE N(+)=1
|
| |
Back To Question | |
