wood burning stoves 2.0*
The moose likes JDBC and the fly likes Any ORacle PL\SQL function - starts with alphapbet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Any ORacle PL\SQL function - starts with alphapbet" Watch "Any ORacle PL\SQL function - starts with alphapbet" New topic
Author

Any ORacle PL\SQL function - starts with alphapbet

Neelima Garimella
Ranch Hand

Joined: Oct 03, 2000
Posts: 37
Hi,
I am just wondering whether there's any oracle PL\SQL function, which tells whether the particular value starts with an alphabet. I want to select values from a table which doesn't start with an alphabet.
Please provide an idea. I think, we can do this using substr , but i guess it'll be expensive.
Thanks
Neelima
Seetesh Hindlekar
Ranch Hand

Joined: Feb 13, 2004
Posts: 244
Hi,
U cld use the ASCII function to check if the first char's ASCII value is between 48 and 57. If yes its a number else its a ALPHABET or any special character.
Similary u can do a check for the ASCII values for A-Z or a-z using a combination of decode.
Seetesh
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Any ORacle PL\SQL function - starts with alphapbet