Casey B
Well-Known Member
I'm in an Intro to Oracle9i SQL class and I'm having trouble with an assignment. Actually just one of the question on the assignment is giving me fits. I thought I would share because of the overwhelming amount of knowledge floating around this site.
SQL built-in function to convert the following string of text.
String, ‘both the UPDATE commands and the ALTER TABLE command’
• replace ‘A’ with ‘b’ in the string.
• Remove ‘UPDATE’ and ‘ALTER’ from the string.
• Find out the position of ‘a’ of ‘and’ in the string.
• Convert the string to upper case and lower case.
I just have to give the syntax for the SQL statement. Thanks in advance.
SQL built-in function to convert the following string of text.
String, ‘both the UPDATE commands and the ALTER TABLE command’
• replace ‘A’ with ‘b’ in the string.
• Remove ‘UPDATE’ and ‘ALTER’ from the string.
• Find out the position of ‘a’ of ‘and’ in the string.
• Convert the string to upper case and lower case.
I just have to give the syntax for the SQL statement. Thanks in advance.