cx_oracle -- how to insert "&"

[Steve Holden]

Allen wrote:
> I am using Python with cx_oracle to load an excel spreadsheet into an
> Oracle table. There are lots of text on the spreadsheet that have "&"
> in them which I want to keep in the table. But inserting those text
> will fail.

Why do you say that?

> Is there a work around for this? I can filter out the
> failed insert statements and in SQLPLUS set define off  to run those
> statements, but it would be nice to insert "&" directly in PYTHON.
> 
regards
 Steve
-- 
Steve Holden        +1 571 484 6266   +1 800 494 3119
Holden Web LLC              http://www.holdenweb.com/