64 712
Assignments Done
99,4%
Successfully Done
In September 2018

Answer to Question #73923 in Databases | SQL | Oracle | MS Access for Todd Boyle

Question #73923
Write a SELECT statement that changes the phrase Today is Monday to Today is Tuesday
Expert's answer
You can use REPLACE function to change the phrase.

Syntax:

replace(<string>,<matching_string>,<replace_with>)

MySQL, SQL Server, PostgreSQL:
SELECT replace('Today is Monday', 'Monday', 'Tuesday') AS phrase;

Oracle:
SELECT replace('Today is Monday', 'Monday', 'Tuesday') AS phrase FROM dual;

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be first!

Leave a comment

Ask Your question

Submit
Privacy policy Terms and Conditions