hi friends
When I type
delete * from tablename where c1=' aaa & bbb';
It is asking to enter a value(run time parameter passing)
Please help me how to delete this row.
thanks and regards
Printable View
hi friends
When I type
delete * from tablename where c1=' aaa & bbb';
It is asking to enter a value(run time parameter passing)
Please help me how to delete this row.
thanks and regards
delete from table_name where c1 = 'aaa '||chr(38)||' bbb';
Hi!
SQL*Plus right?
set define off
It cancels special meaning for ampersand character - '&'
thank you guys