Skip to content

Instantly share code, notes, and snippets.

@velll

velll/get_all_substr_with_connect_by.sql

Created April 17, 2017 11:25
Show Gist options
  • Save velll/b25ddca9e1ccdbfc9a070f810a518612 to your computer and use it in GitHub Desktop.
Save velll/b25ddca9e1ccdbfc9a070f810a518612 to your computer and use it in GitHub Desktop.
Download ZIP
Substrings with connect by
Raw
get_all_substr_with_connect_by.sql
SELECT SUBSTR('123232', 1, LENGTH('123232') - LEVEL + 1),
LENGTH('123232') - LEVEL + 1 N_PREFIX_LENGTH
FROM DUAL
CONNECT BY SUBSTR('123232', 1, LENGTH('123232') - LEVEL + 1) IS NOT NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment