Please assume you have the following string, stored in a VARCHAR2(4000):
ASTRING = '**NE**NECOLL1**NECOLL2**NE37509999**';
Using double-asterisk (==> **) as separator, I would like to write a VIEW script:
CREATE OR REPLACE VIEW STRING_SPLITTER AS SELECT ...........
The VIEW STRING_SPLITTER has to produce the following output, if SELECTed:
SELECT * FROM STRING_SPLITTER;
4 row(s) selected