Escape Character in SQL

Oracle 9i

Is there a way (an escape character) to get a tick in the selection criteria without getting the error:
"ORA-01756 quoted sting not properaly teminated"?


For example
select 'Ted's assignment' from dual;

Use two single tics to escape it.

Code:

---

select 'Ted''s assignment' from dual;

---