OT: Anyone good with Oracle9i SQL?

[Casey B]

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.

 

[Richard Gosdin]

I dont know Oracle, just Microsoft. Maybe this will help you get started.



-- replace ‘A’ with ‘b’ in the string.

SELECT REPLACE('both the UPDATE commands and the ALTER TABLE command’,'A','b')

GO



-- Remove ‘UPDATE’ and ‘ALTER’ from the string.

SELECT REPLACE('both the UPDATE commands and the ALTER TABLE command’,'UPDATE','')

GO



SELECT REPLACE('both the UPDATE commands and the ALTER TABLE command’,'ALTER','b')

GO



-- Find out the position of ‘a’ of ‘and’ in the string.

SELECT CHARINDEX('a','both the UPDATE commands and the ALTER TABLE command')

GO



-- Convert the string to upper case and lower case.



SELECT UPPER('both the UPDATE commands and the ALTER TABLE command’)

GO



SELECT LOWER('both the UPDATE commands and the ALTER TABLE command’)

GO

 

[Casey B]

Thanks RichardG. I turned in the assignment last night. I was really unsure abouth location of 'a' command but I figured the others out. I don't recall seeing CHARINDEX in the Oracle text but I used some other command. I don't have the assignment with me and I can't remember exactly what I put. I guess I'll find out when it's graded. Thanks for the input.

 

[WXMotorSports DecalsPartsAccs]

I've been out of the SQL/Oracle for about 4 years now. However, the commands are close to SQL. I'd go to the some of the Oracle forums for the info.