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

What is an index associated with a constraint?

744

Explain the use of rows option in imp command.

765

How to define an anonymous procedure without variables?

725

How do I limit the number of oracle database connections generated by weblogic server?

782

How to create id with auto_increment on oracle?

733

How to convert numbers to characters in oracle?

762

Can we protect our pl/sql source code?

760

How to convert times to characters in oracle?

783

How to add another datafile to a tablespace?

788

what are the advantages of running a database in archive log mode?

1919

What is the sid in oracle?

686

what is the difference between data migration and production migration.

2027

What is null value in oracle?

820

Explain the use of online redo log files in oracle.

758

Please explain oracle left join with an example?

750