Get Week Number in PLSQL

SELECT TO_NUMBER(TO_CHAR(TO_DATE('06/14/2018', 'MM/DD/YYYY'), 'WW')) FROM DUAL;

SELECT TO_NUMBER(TO_CHAR(TO_DATE(SYSDATE, 'DD/MM/YYYY'), 'WW')) FROM DUAL;