any one explain this query:
select regexp_substr(char_name,'[^,]+',1,level)as row_id from char_change
connect by level<=(select length(replace(char_name,',',null)) from char_change);
this query is used to get the string value and print the row wise.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!