If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Changing Oracle String Delimiter

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??

Re: Changing Oracle String Delimiter

Originally posted by djtomr941 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??