title: How to convert semicolon separated column into a row in Oracle?
body: <pre><code> Source Table: EMP_LOCATION
  
   NAME    LOCATION
   -------------------------------
   SMITH     NY;CA;IL;GA
   JAMES     MO;AZ;RI
   FORD      NJ
   SCOTT     TX;VA;WA;NH
   MARTIN    MD;CT
  
  Required Output:
  
  NAME    LOCATION
  -------------------
  FORD      NJ
  JAMES     AZ
  JAMES     MO
  JAMES     RI
  MARTIN    CT
  MARTIN    MD
  SCOTT     NH
  SCOTT     TX
  SCOTT     VA
  SCOTT     WA
  SMITH     CA
  SMITH     GA
  SMITH     IL
  SMITH     NY
  </code></pre>