Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select BANNER from V$VERSION WHERE ROWNUM = 1


BANNER


Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production


CREATE TABLE MY_TABLE (
 ID INT PRIMARY KEY, 
 ALL_PERIODS VARCHAR(30), 
 DATE_ DATE, 
 YEAR_ INT, 
 QUARTER_ INT
)
INSERT INTO MY_TABLE (ID, ALL_PERIODS)
          SELECT 1, 'JFM 14 - W/E 04/05/14' FROM DUAL
UNION ALL SELECT 2, 'OND 14 - W/E 12/15/14' FROM DUAL
UNION ALL SELECT 3, NULL FROM DUAL
3 rows affected

UPDATE MY_TABLE
SET 
 DATE_ = TO_DATE(SUBSTR(RTRIM(ALL_PERIODS),-8),'MM/DD/YY')
,YEAR_ = 2000+SUBSTR(ALL_PERIODS,5,2)
,QUARTER_ = DECODE(SUBSTR(ALL_PERIODS,1,3), 'JFM', 1, 'AMJ', 2, 'JAS', 3, 'OND', 4)
WHERE ALL_PERIODS IS NOT NULL 
  AND DATE_ IS NULL
2 rows affected

SELECT *
FROM MY_TABLE
ORDER BY ID


ID
ALL_PERIODS
DATE_
YEAR_
QUARTER_


1
JFM 14 - W/E 04/05/14
05-APR-14
2014
1

2
OND 14 - W/E 12/15/14
15-DEC-14
2014
4

3
null
null
null
null

ID	ALL_PERIODS	DATE_	YEAR_	QUARTER_
1	JFM 14 - W/E 04/05/14	05-APR-14	2014	1
2	OND 14 - W/E 12/15/14	15-DEC-14	2014	4
3	null	null	null	null