Query to display string in vertical form

INPUT

WELCOME

OUTPUT

The Query

select substr('welcome',level,1) str from dual connect by level<=length('welcome');

Leave a Reply