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
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
No comments:
Post a Comment