This week's book giveaway is in the Mac OS forum. We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell 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