HELP - How can Oracle accept the '&' character in a string???

[Jenny O'Brien]

Hi,

I'm trying to populate an Oracle database with a string containing and
ampersant ('&' character). Do you have any ideas?? I've tried enclosing it
in double and singe quotes and I've tried '&&' but no luck !

Any help would be greatly appreciated.

Thanks,
Jenny

[NetComrade]

in sqlplus:
set escape="\"
insert values('United \& States') into countries

[Roman Starek]

: I'm trying to populate an Oracle database with a string containing and

: ampersant ('&' character). Do you have any ideas?? I've tried enclosing it
: in double and singe quotes and I've tried '&&' but no luck !

If you are talking about SQLPlus try this setting

set scan off

Starous

[Holden]

hmm....

how are you trying to do it?

you could try this:

SQL> set escape \
SQL> insert into foo values
2 ('test\&test');

1 row created.

SQL> select * from foo;

FOOTEST
--------------------
test&test

HTH
-Holden

On Fri, 29 Sep 2000 15:45:32 +0100, "Jenny O'Brien"
<jen...@peregrine.ie> wrote:

>Hi,
>

>I'm trying to populate an Oracle database with a string containing and
>ampersant ('&' character). Do you have any ideas?? I've tried enclosing it
>in double and singe quotes and I've tried '&&' but no luck !
>

[frank]

And now for the short and easy way:
set define off.

SQL> create table foo (b varchar2(40));
Table created.

SQL> set define off
SQL> insert into foo values('Gall&Gall');
1 row created.

SQL> select * from foo;

B
----------------------------------------
Gall&Gall

Grtz, Frank