How do to insert '&' character from sqlplus ?

[Database Administrator]

Hi,

When I try to insert the '&' in a VARCHAR column I get a message from oracle.

How can I insert '&' character from sqlplus ?

Thanks,
Jose Luis.

[Database Administrator]

In article , jose luis
fernandez diaz says...
> Hi,
>
> When I try to insert the '&' in a VARCHAR column I get a message from oracle.
>
> How can I insert '&' character from sqlplus ?


& is the 'define' character in sqlplus by default.

So either

SQL> set define off
or choose another symbol e.g.
SQL> set define }

and be sure not to use } in any sql statement!

--

jeremy

[Database Administrator]

In article , jose luis
fernandez diaz says...
> Hi,
>
> When I try to insert the '&' in a VARCHAR column I get a message from oracle.
>
> How can I insert '&' character from sqlplus ?


& is the 'define' character in sqlplus by default.

So either

SQL> set define off
or choose another symbol e.g.
SQL> set define }

and be sure not to use } in any sql statement!

--

jeremy

[Database Administrator]

In article , jose luis
fernandez diaz says...
> Hi,
>
> When I try to insert the '&' in a VARCHAR column I get a message from oracle.
>
> How can I insert '&' character from sqlplus ?


& is the 'define' character in sqlplus by default.

So either

SQL> set define off
or choose another symbol e.g.
SQL> set define }

and be sure not to use } in any sql statement!

--

jeremy

[Database Administrator]

In article , jose luis
fernandez diaz says...
> Hi,
>
> When I try to insert the '&' in a VARCHAR column I get a message from oracle.
>
> How can I insert '&' character from sqlplus ?


& is the 'define' character in sqlplus by default.

So either

SQL> set define off
or choose another symbol e.g.
SQL> set define }

and be sure not to use } in any sql statement!

--

jeremy

[Database Administrator]

In article , jose luis
fernandez diaz says...
> Hi,
>
> When I try to insert the '&' in a VARCHAR column I get a message from oracle.
>
> How can I insert '&' character from sqlplus ?


& is the 'define' character in sqlplus by default.

So either

SQL> set define off
or choose another symbol e.g.
SQL> set define }

and be sure not to use } in any sql statement!

--

jeremy

[Database Administrator]

In article , jose luis
fernandez diaz says...
> Hi,
>
> When I try to insert the '&' in a VARCHAR column I get a message from oracle.
>
> How can I insert '&' character from sqlplus ?


& is the 'define' character in sqlplus by default.

So either

SQL> set define off
or choose another symbol e.g.
SQL> set define }

and be sure not to use } in any sql statement!

--

jeremy

[Database Administrator]

In article , jose luis
fernandez diaz says...
> Hi,
>
> When I try to insert the '&' in a VARCHAR column I get a message from oracle.
>
> How can I insert '&' character from sqlplus ?


& is the 'define' character in sqlplus by default.

So either

SQL> set define off
or choose another symbol e.g.
SQL> set define }

and be sure not to use } in any sql statement!

--

jeremy

[Database Administrator]

"jose luis fernandez diaz" wrote in message
news:c2f95fd0.0407080712.5d5b70ee@posting.google.c om...
> Hi,
>
> When I try to insert the '&' in a VARCHAR column I get a message from oracle.
>
> How can I insert '&' character from sqlplus ?
>
> Thanks,
> Jose Luis.

Try googling for a change.

Go to Google groups .. and type in oracle ampersand

You should be able to get the various solutions.

Anurag

[Database Administrator]

"jose luis fernandez diaz" wrote in message
news:c2f95fd0.0407080712.5d5b70ee@posting.google.c om...
> Hi,
>
> When I try to insert the '&' in a VARCHAR column I get a message from oracle.
>
> How can I insert '&' character from sqlplus ?
>
> Thanks,
> Jose Luis.

Try googling for a change.

Go to Google groups .. and type in oracle ampersand

You should be able to get the various solutions.

Anurag