Oracle 11g Release 2

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

CREATE TABLE SOME_TABLE(A_STRING) AS
  SELECT 'status := off; status:= on;' FROM DUAL
1 rows affected

SELECT *
  FROM SOME_TABLE

A_STRING

status := off; status:= on;

SELECT TRIM(REGEXP_SUBSTR(A_STRING,'[^;]+',1,LEVEL)) ELEMENT
  FROM SOME_TABLE
  CONNECT BY LEVEL <= LENGTH(REGEXP_REPLACE(A_STRING,'[^;]+')) + 1

ELEMENT

status := off

status:= on

null