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

4 Answers
7392 Views
Attra, Metric Stream, I also Faced
E-Mail Answers

Answer Posted / pradeep

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

Is This Answer Correct ?

15 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is index in Oracle?

1081

How to use like conditions in oracle?

1072

various types of hints and their usage

2707

what is normalisation?what are its uses?

2282

What is control file used for?

1225

What is a static data dictionary in oracle?

1122

What is the difference between a primary key & a unique key?

1099

What happens in oracle commit?

1039

How to execute a stored program unit?

1087

What is oracle database 10g express edition?

1131

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2017

How to call a stored function with parameters?

1051

What is a Garbage Collection? and what is full recursive Garbage collection?

2912

How can you use check constraints for self referential integrity?

979

What is an index associated with a constraint?

1044