Convert a row into a column

SELECT
SUBSTR('GREAT',a,1) GREAT
FROM
(
SELECT
ROWNUM a
FROM
DUAL
CONNECT BY
LEVEL <= LENGTH('GREAT')
);

Output :-

G
R
E
A
T