Before you can do anything you need to convert the text to a date using
TO_DATE[
^].
With the date you can use
TO_CHAR[
^] to get the quarter in which the date belongs.
Both functions use
Datetime Format Elements[
^].
SELECT ctrl_no, a_code, prj_code
FROM tbltrans
WHERE TO_CHAR( TO_DATE( date_created, 'DD Month YYYY', 'nls_date_language = us' ), 'Q') = '1'