Select SUBSTR('NISHI',LEVEL,1) from dual CONNECT BY LEVEL<=l

how to i write the query 'NISHI' TO
N
I
S
H
I

Question Posted / pradeep

Answer Posted / pradeep

Select SUBSTR('NISHI',LEVEL,1) from dual
CONNECT BY LEVEL<=length('NISHI')

Is This Answer Correct ?

15 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to pass parameters to procedures?

1034

Explain what are the uses of rollback segment?

1016

Give the advantages and disadvantages of clusters.

1051

What to do if the startbd.bat failed to start the xe instance?

1083

What is PL/SQL ?

2071

how to do daily transactions with out sql* loader control file regesterd in apps?

1687

How can I create database in oracle?

1027

How to select all columns of all rows from a table in oracle?

1053

How to install oracle odbc drivers?

1093

Give the various rollback segment states.

1052

what is port in oracle? how is it related to database application.

1949

How to recover a dropped table in oracle?

1048

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1046

if you ctreate table identity

2374

What is a relational database management system?

1120