A To Z Print

SELECT CHR(X.RNO +64) "ALPHA" FROM (
SELECT LEVEL RNO
FROM DUAL
CONNECT BY LEVEL <= 26 ) X

Schema using tablespace

SELECT SUM (BYTES) / 1024 / 1024 mb
FROM dba_segments
WHERE owner = 'HR';