How to insert & in oracle using toad?

sql oracle toad

Rose · May 7, 2011 · Viewed 38.5k times · Source

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

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.