Split varchar into separate columns

I've been asked to take in comments starting with a specific string from a database, and separate the result into separate columns.

For example -- if a returned value is this:

COLUMN_ONE
--------------------
'D7ERROR username'

The return needs to be:

COL_ONE    COL_TWO
--------------------
D7ERROR   username

Is it even possible to define columns once the result set has been structured just for the sake of splitting a string into two?

sql oracle-database

Edit Report

1 Answer