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 is meant by joins? List out the types of joins.
List out the difference between commit, rollback, and savepoint?
How to execute a stored procedure in oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What is using clause and give example?
How to turn on or off recycle bin for the session?
Explain the difference between a procedure and a function? What do you understand by those terms?
What are the different types of trigger and explain its various uses and functions?
What privilege is needed for a user to delete rows from tables in another schema?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to define a cusotmer as a supplier in ORACLE R12
What are the different types of partitions in oracle?
What is the difference between primary key and unique key and foreign key in oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
20. Using a set operator, display the client number of all clients who have never placed an order.