How to insert & in oracle using toad? [duplicate]

Question

Possible Duplicate:
select * from table_name where column like '&nbsp'

How do you insert the & symbol as data in an Oracle database, using Toad? Example:

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

When executing script asking new value for T...

Answer 1

Use this:

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

You can also try using:

set define off;

In your environment so &Something won't be treated as if it is an input variable. But I don't know where to put that in TOAD.

Answer 2

SET DEFINE OFF will stop sqlplus interpreting & this way.

this will also work

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