2. testcol VARCHAR2(50));
3.
4. INSERT INTO regexp
5. (testcol)
6. VALUES
7. ('One|Two|Three|Four|Five');
8.
9. SELECT * FROM regexp;
10.
11. SELECT REGEXP_SUBSTR(testcol,'[^|]+', 1, 3)
12. FROM regexp;
CREATE TABLE regexp ( testcol VARCHAR2(50)); INSERT INTO regexp (testcol) VALUES ('One|Two|Three|Four|Five'); SELECT * FROM regexp; SELECT REGEXP_SUBSTR(testcol,'[^|]+', 1, 3) FROM regexp;
Equivalence classes
1. SELECT REGEXP_SUBSTR('iSelfSchooling NOT ISelfSchooling', '[[=i=]]SelfSchooling') RESULT
2. FROM dual;
SELECT REGEXP_SUBSTR('iSelfSchooling NOT ISelfSchooling', '[[=i=]]SelfSchooling') RESULT FROM dual;