how to insert '&' in SQL*Plus

[Guest_imported]

Hi all,

anybody knows how to update a table column with '&'
e.g. update TableA set COL1='John & Mary';
where '&' is included, it is treated as parameter, anyway to workaround?

thanks

 

[stefanhei]

Hi.
Try set esc then update TableA set COL1='John \& Mary';

Stefan

 

[Guest_imported]

many thanks Stefan!