×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Jon Nickerson
Added: Nov 14, 2017 8:42 PM
Views: 2
Tags: no tags
  1. SELECT DISTINCT
  2.   regexp_substr(to_split, '[^-]+', 1, level) AS one_element,
  3.   LEVEL
  4. FROM Zexec.split_tab
  5. CONNECT BY regexp_substr(to_split, '[^-]+', 1, level) IS NOT NULL