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 the use of system.effective.date variable in oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What is max rowid in oracle?
Is there a function to split a string in plsql?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
How do we display rows from the table without duplicates?
What are the different oracle database objects?
How to Truncate Table in Oracle
What privilege is needed for a user to delete rows from tables in another schema?
What are the predefined tablespaces in a database?
why dont we assign not null constraint as table level constraint.
How to define an oracle cursor variable?
How do I manually uninstall oracle client?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What are ddl statements in oracle?