By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT SUBSTR('VELOCITY', LEVEL, 1) AS ch
FROM DUAL
CONNECT BY LEVEL <= LENGTH('VELOCITY');
| CH |
|---|
| V |
| E |
| L |
| O |
| C |
| I |
| T |
| Y |
CREATE TABLE table_name (value) AS
SELECT 'VELOCITY' FROM DUAL UNION ALL
SELECT 'OTHER' FROM DUAL;
2 rows affected
SELECT c.ch
FROM table_name t
INNER JOIN LATERAL (
SELECT SUBSTR(t.value, LEVEL, 1) AS ch
FROM DUAL
CONNECT BY LEVEL <= LENGTH(t.value)
) c
ON (t.value IS NOT NULL)
| CH |
|---|
| V |
| E |
| L |
| O |
| C |
| I |
| T |
| Y |
| O |
| T |
| H |
| E |
| R |