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 would you best determine why your MVIEW couldnt FAST REFRESH?

1836

What is the relationship among database, tablespace and data file?

929

How does the on-delete-cascade statement work?

1061

ABOUT IDENTITY?

2006

Explain a segment?

1021

How to create a stored program unit?

1121

What are the oracle differences between nvl and coalesce

1069

Is it possible to insert comments into sql statements return in the data model editor ?

2513

Please explain compound trigger in oracle?

996

How to start your 10g xe server from command line?

1001

Is oracle an open source?

1021

What is the difference between post-database commit and post-form commit?

1108

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2295

How many types of cluster table in Oracle?

987

Is oracle a programming language?

940