Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Any ORacle PL\SQL function - starts with alphapbet

 
Neelima Garimella
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 244
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic