This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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
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