plsql - How to split a column using only Sql? -

Let's say that my table is like,

  data ---- smith700 < / Code> 

Then my output should be

  name sal ----- --- smith 700  

I only Can I use a SQL statement that is a PL / SQL statement allowed ... how to do it?

use

  SELECT SUBSTR ('smith700', 1, 5), SUBSTR ('smith700', 6,3)  

UPDATE

For the different lengths of numbers and letters you You can try

  SELECT REGEXP_REPLACE ('smith700', '[a-za-z]', '') with double; SELECT REGEXP_REPLACE ('smith700', '[0-9]');