how to i write the query 'NISHI' TO
N
I
S
H
I
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
What are the differences between interval year to month and interval day to second?
How many types of table in Oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Where do we use decode and case statements?
What is meant by joins?
How to list all user accounts in oracle?
How to assign values to variables?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What is Segment Advisor in Oracle?
How to convert a date to char in oracle? Give one example.
Why does for update in oracle 8 cause an ora-01002 error?
Explain the use of grant option in imp command.
How to load data from external tables to regular tables?
Differentiate between pre-select and pre-query?
Explain table?