Oracle escaping the single quote(') in a select

This query will fail when doing a select statement:

select * from table_name where field='it's friday today';



To escape the single quote (') you need to add in another single quote (''):

select * from table_name where field='it''s friday today';