How to insert & into oracle using a toad?

Question

Possible duplicate:
select * from table_name, where the column is of type '& nbsp'

How do you insert data & symbolinto an Oracle database using Toad? Example:

INSERT INTO <table_name> 
  (column)
VALUES 
  ('AT & T');

When executing a script requesting a new value for T ...

+3

Rose May 07, '11 at 13:10

2 answers

Pablo santa cruz · Answer 1 · 2011-05-07T13:16:00+0000

Use this:

insert into my_table values ('AT &' || 'T');

You can also try:

set define off;

Your environment &Somethingwill not be processed as if it were an input variable. But I do not know where to put this in TOAD.

mr_eclair · Answer 2 · 2011-05-07T13:19:43+0000

SET DEFINE OFF will stop sqlplus interpretation and that way.

it will also work

set define off;
insert into tablename values( 'AT & T');