character escapes

this is new to me...

insert into some_table
(

  some_column
)
values
(

  'ng&e'
)

the character & seems to be a special character for oracle. how do i properly escape it...and, are there any more characters that could foul an otherwise ansi compliant sql statement if they are not escaped?

tia,

steve Received on Wed Aug 18 2004 - 22:09:01 CDT