var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: need sql query
I need query to split string into individual characters and each character will display in separate row.
For Example, I have a word like mysweet the output should be
I am new to oracle.can you please provide the query for this.
Thanks in Advance
Here you go:
SQL> with test as (select 'mysweet' col from dual)
2 select substr(col, level, 1) letter
3 from test
4 connect by level <= length(col);
7 rows selected.