Re: Insert special characters from SQL-Plus

Franck Formis wrote in message <8tEW3.86$U67.71088_at_news>...
>Hi,
>
> Is there anybody knowing how to insert a string like "you & me" in a
>table from SQL-PLus ?
>Doing it straight forward give you back the following error :
>
>SQL> insert into emp (EMPNO, ENAME) values (8000,you & me);
>Enter value for me:
>
>Thanks,
>
>Franck Formis
>
>

Hi,

If you do not use "&variables" in your SQL script just execute SQL*Plus command:
  set define off
When you need to use "&variables" execute command:   set define #
which enables you to use "#variables" in place of "&variables" (you can of course choose any single nonalphanumeric character to mark your variables).

Use 'single quotes' for your text data, do not use "double quotes".

Waldek Karczmarczyk, ABG SA
wak_at_abg.com.pl Received on Fri Nov 12 1999 - 11:26:36 CST