AW: Sql terminator ; in q syntax query block

Perfect! Thanks.

Mike

http://www.strychnine.co.uk <http://www.strychnine.co.uk/>

> Am 17/03/2021 um 18:55 schrieb Maxim <mdemenko_at_gmail.com>:
>
> You could assign sqlterminator to another character, or is this, what you mean with "replace" ?
>
> SQL> set sqlterminator /
> SQL> select q'{A,B,C,D;
> 2 E,F,G,H;
> 3 I,J}' x
> 4 from dual
> 5 /
>
> X
> ---------------------
> A,B,C,D;
> E,F,G,H;
> I,J
>
> Regards
>
> Maxim
>
> On Wed, Mar 17, 2021 at 7:30 PM Michael D O'Shea/Woodward Informatics Ltd <woodwardinformatics_at_strychnine.co.uk <mailto:woodwardinformatics_at_strychnine.co.uk>> wrote:
> Hi chaps, it’s an anonymised example but does represent an ongoing issue I have at the moment.
>
> Other than replacing the semicolon with another character, does anyone know whether the SQL terminator can be turned off? There is nothing obvious showing up with a „help set“ in sqlplus. I am surprised that this is even an issue given the multiline string is inside a q syntax block, but it is.
>
> Mike
> http://www.strychnine.co.uk <http://www.strychnine.co.uk/>
>
>
>
>
> SQL>
> SQL>
> SQL>
> SQL> select q'[A,B,C,D;
> ERROR:
> ORA-01756: quoted string not properly terminated
>
>
> SQL> E,F,G,H;
> SP2-0042: unknown command "E,F,G,H" - rest of line ignored.
> SQL> I,J]' x
> SQL> from dual;
> SP2-0042: unknown command "from dual" - rest of line ignored.
> SQL>
> SQL>
> SQL>
> SQL>
> SQL>
> SQL> select banner from v$version;
>
> BANNER
> --------------------------------------------------------------------------------
> Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
>
> SQL>
>

--
http://www.freelists.org/webpage/oracle-l