This is probably a very easy question but i'm new to Oracle and I'm working through some problems in a book I picked up which prepares you for the certification exam. Here's the question.
Using the built in functions
Find the position of the 'a, and, the" in the sring
Remove the words ALTER and UPDATE from a string.
convert the string to upper case and lower case. (I've played with this and think I can handle it unless you think there's something I need to know.)
convert abcd to $9999.
Any help would be greatly appreciated.