Thanks for the question, ABBY.
Asked: August 11, 2016 - 7:23 am UTC
Last updated: August 11, 2016 - 9:12 am UTC
Version: 11g database release 2
Viewed 1000+ times
with t as ( select 1 id, '100A-5567RT-009UY-890IK' str from dual ) select id, subs from t, xmltable( 'if (contains($X,"-")) then ora:tokenize($X,"\-") else $X' passing str as X columns subs varchar2(4000) path '.' ); ID SUBS 1 100A 1 5567RT 1 009UY 1 890IK
Robert, August 11, 2016 - 9:55 am UTC
Get all the information about database performance in the Database Performance guide.