SQL Help?

Toad for Oracle
1

Hi there,

I have a table that has a number of records like the one below :

1122_Carlingford_005_040_089
1341_West_Ryde_005_030_089
3304_QV_005_040_089

How would the SQL go in Toad if i wanted to pull out the data and split it into each individual colums :

  • pull out the first 4 numbers without the underscore,
  • the Name without the Underscore
  • 005 by itself

Your help is much appreciated. Still new to SQL and Toad