oracle sql developer

1/* Answer to: "oracle SQL developer" */
2
3/*
4  Oracle SQL Developer is an Integrated development environment for
5  working with SQL in Oracle databases. Oracle Corporation provides
6  this product free; it uses the Java Development Kit.
7
8  Download it here:
9  https://www.oracle.com/tools/downloads/sqldev-downloads.html
10*/

1Select
2  REGEXP_SUBSTR(Column1,'\Name=([^.]+)',1,1,null,1) as Name
3, regexp_substr(Column1,'\Branch Number=([^.]+)',1,1,null,1) as Branch_Number
4, regexp_substr(Column1,'\Type of Event=([^.]+)',1,1,null,1) as Type_of_Event
5, regexp_substr(Column1,'\Date of Event=([^.]+)',1,1,null,1) as Date_of_Event
6
7From table1
8
9Where...
10