This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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
 
Similar Threads
prepare Oracle OPCA ceterfication
Stored Procedures
sql question
Stroed Procedure&PL/SQL
plsql mathematical function