Answers for "oracle sql developer and sql server"

oracle SQL developer

/* Answer to: "oracle SQL developer" */

/*
  Oracle SQL Developer is an Integrated development environment for
  working with SQL in Oracle databases. Oracle Corporation provides
  this product free; it uses the Java Development Kit.

  Download it here:
  https://www.oracle.com/tools/downloads/sqldev-downloads.html
*/

Oracle SQL Developer

Select
  REGEXP_SUBSTR(Column1,'Name=([^.]+)',1,1,null,1) as Name
, regexp_substr(Column1,'Branch Number=([^.]+)',1,1,null,1) as Branch_Number
, regexp_substr(Column1,'Type of Event=([^.]+)',1,1,null,1) as Type_of_Event
, regexp_substr(Column1,'Date of Event=([^.]+)',1,1,null,1) as Date_of_Event

From table1

Where...