Inserting records - list of chars that need to be escaped?
inserting a record, the field is type varchar2.
the string i want to insert contains both left and right parentheses - do i need to escape them? i was looking for a list of what characters need to be escaped when inserting in varchar2 but didn't see one.
thanks in advance!
example...
insert into mytable (field1, field2) values ('value1', 'this one contains special chars ( )');