Created
October 25, 2023 09:55
-
-
Save wwwy3y3/c8b483c776ee81f5b85a0a28a6e1c1ea to your computer and use it in GitHub Desktop.
oracle
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
'U+' || TO_CHAR(TO_NUMBER(UNICODE(TO_NCHAR(REGEXP_SUBSTR(my_column, '.', 1, LEVEL)))), 'FMXXXX') | |
AS unicode_str | |
FROM my_table | |
CONNECT BY PRIOR dbms_random.value IS NOT NULL | |
AND PRIOR my_column = my_column | |
AND PRIOR sys_guid() IS NOT NULL | |
AND LEVEL <= LENGTH(my_column); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment