how to i write the query 'NISHI' TO N I S H I

how to i write the query 'NISHI' TO
N
I
S
H
I

Question Posted / nishi.swain@gmail.com

4 Answers
5863 Views
Attra, Metric Stream, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to i write the query 'NISHI' TO N I S H I..

Answer / pradeep

Select SUBSTR('NISHI',LEVEL,1) from dual
CONNECT BY LEVEL<=length('NISHI')

Is This Answer Correct ?

15 Yes

1 No

how to i write the query 'NISHI' TO N I S H I..

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

how to i write the query 'NISHI' TO N I S H I..

Answer / karthik

SELECT 'NISHI' NAME FROM DUAL;

COLUMN NAME FORMAT A1
/

Is This Answer Correct ?

1 Yes

3 No

how to i write the query 'NISHI' TO N I S H I..

Answer / madhu

Select To_char('N I S H I') from dual

Is This Answer Correct ?

2 Yes

6 No

Post New Answer