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
- 7242 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 the use of Control File ?
Explain the use of record length option in exp command.
How to select some columns from a table in oracle?
What is the purpose of a cluster?
How do I uninstall oracle client from windows?
How different is ms access and oracle?
How would you design a database for an e-commerce website?
when do u go for hash partitioning?
What is the function of Redo Log ?
what is the bitmap index?
What is an oracle function?
find out first highest salary?
10 Answers Verinon Technology Solutions,
Oracle General 
