create table test_45(a varchar2(25));

insert into test_45 values('employees'||''''||'status');

SQL> select * from test_45;

A
-------------------------
employees'status

SQL> update test_45 set a='employee'||''''||'s status';

1 row updated.

SQL> select * from test_45;

A
-------------------------
employee's status

SQL> SELECT 'employee''s status' method_one
  2       , q'$employees's status$' method_two
  3  FROM dual
  4  /

METHOD_ONE        METHOD_TWO
----------------- ------------------
employee's status employees's status