Protected by Copyscape Web Copyright Protection Software

Search This Blog

Friday, December 6, 2013

How to Display String Vertically in Oracle?

Query to display string vertically by Oracle:

SELECT SUBSTR ('&&STRING', ROWNUM, 1) Vertical
FROM DBA_OBJECTS
WHERE ROWNUM <= LENGTH (TRIM ('&STRING'));
The qwery asks String when execute in Toad or Sql Developer. Then Give String Like Rajashekar, Then it will display it as shown below.

R
a
j
a
s
h
e
k
a
r