<div>
If you want an apostrophe inside of your statemnt you have to double them, e.g: 'this ''is a'' string with ''apostrophes'''. <br />
Hope this helps.
</div>


If you want an apostrophe inside of your statemnt you have to double them, e.g: 'this ''is a'' string with ''apostrophes'''.
Hope this helps.

<div>
Thanks, see my new Q about loging users out!<br />

</div>


Thanks, see my new Q about loging users out!


<div>
<div class="content wysiwyg-content">
Hi......<br />
I'm using Perl-DBI to extract data from Oracle.<br />
My selects and inserts have apostrophes in them.<br />
This breaks my sql statement with...........<br />
&quot;quoted string not properly terrminated.&quot;<br />
help, the same happens when I try and escape the \' in sqlplus.<br />
cheers
</div>
</div>


Hi......
I'm using Perl-DBI to extract data from Oracle.
My selects and inserts have apostrophes in them.
This breaks my sql statement with...........
"quoted string not properly terrminated."
help, the same happens when I try and escape the \' in sqlplus.
cheers

Apostrophes break my query?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.