The default delimiter in Oracle is a quote or apostrophe ' , What I would like to do is change the delimiter in the session. Is there anyway to do this with Alter session or a SQL PLUS command where I can change the delimiter such as the SET command. I looked through the SET Command and I see things such as cmdsep and colsep, but nothing for delimiting or encapsulating strings.

What I need to do is insert a character value that has apostrohpes, so before I insert I want to change the delimiter to something else and then do an insert such as [this is the string values that don't go ' ' ' '' ''' string etc... ] . So that it will insert everything between that and ignore ' as the seperator??

Thanks