Interested to Buy Any Domain ? << Click Here >> for more details...
how to i write the query 'NISHI' TO
N
I
S
H
I
- 4 Answers
- 7303 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
What is a select query statement in oracle?
Differentiate between function and procedure in oracle.
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is the difference between primary key and unique key and foreign key in oracle?
How to define an anonymous block?
What is a nested table and how is it different from a normal table?
Explain oracle insert into command?
Explain the use of control file?
What is analyze command used for?
What is the difference between count (*), count (expression), count (distinct expression)?
What is a data dictionary and how can it be created?
Can a formula column be obtained through a select statement ?
Explain the difference between a procedure and a function?
How to find the duplicate rows count from employees table in oracle?
