A Gentle Introduction to

SQL

NEW.

These questions have been submitted by users.



How do you change the string delimiter from ' in oracle
for a translate function I need to retain single quotes in a string. To do that easily I would like to change the system string delimeter from ' to # for the duration of that query.
oracle variations:
None

access
db2
mysql
oracle
postgres
sqlserver