title: How to split a string in multiple places in Oracle SQL
body: <p>I have some sql that brings back information about the geometry of jobs.</p>
  <p>very simply this is</p>
  <pre><code>select
  job.job_number,
  job.WKT_values
  from
  job
  </code></pre>
  <p>the job.WKT_values field brings back information about the location of the job (latitude and longitude) in the following format</p>
  <pre><code>POINT (-2.534981 52.14983)
  </code></pre>
  <p>what i would like to is add some code to the report so that the -2.534981 appears in one column and 52.14983 appears in another column and I can then pull these straight into power bi for mapping.</p>
  <p>how do i go about editing the sql so that it splits the field based on a &quot;(&quot; for the first split and then a space for the second split?</p>