how to i write the query 'NISHI' TO
N
I
S
H
I
- 4 Answers
- 6455 Views
- Attra, Metric Stream, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pradeep
Select SUBSTR('NISHI',LEVEL,1) from dual
CONNECT BY LEVEL<=length('NISHI')
| Is This Answer Correct ? | 15 Yes | 1 No |
Answer / ajit nayak
DECLARE
V_NAME VARCHAR2(9);
V_LEN NUMBER;
V_POS VARCHAR2(10) := NULL;
BEGIN
V_NAME := '&ENTERNAME';
FOR I IN 1..LENGTH(V_NAME)
LOOP
V_POS := SUBSTR(V_NAME,I,1);
DBMS_OUTPUT.PUT_LINE(V_POS||CHR(10));
END LOOP;
END;
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / karthik
SELECT 'NISHI' NAME FROM DUAL;
COLUMN NAME FORMAT A1
/
| Is This Answer Correct ? | 1 Yes | 3 No |
What is an Index Segment ?
Can we create more than one index on particular column?
How to test null values?
How to download oracle database 10g xe?
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?
How many memory layers are in the shared pool?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.
5 Answers Microsoft, Oracle, TCS,
How to turn on or off recycle bin for the session?
what is meant by magic query
how the indexes are stored in the Oracle Database?
Explain what are the advantages of views?
Oracle General 
