How to escape an sql query in Oracle
Just add an extra single quote next to any single quote.
For example,
sqlplus> select * from table where column='What''s on the floor?';
[Click to add or edit comments])
Please prepend comments below including a date