| |
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
|
| June 06, 2009 06:01:53 |
#2 |
| PratikshaD |
Member Since: January 2009 Total Comments: 1 |
RE: 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
|
| You can use translate function.translate(,'~0123456789','~') will return null if the input is numeric. Not null if the input is alphanumeric. |
| |
Back To Question | |
