how to i write the query 'NISHI' TO
N
I
S
H
I
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 |
How to use group functions in the select clause using oracle?
What is use of oracle?
Explain user account with reference to oracle.
What is a Database instance ? Explain?
What is Data Dictionary Cache in Oracle?
What are the ansi data types supported in oracle?
What is dictionary cache ?
What is a partition in oracle?
What are the differences between interval year to month and interval day to second?
How to store pictures on to the database?
How to insert a record into a table?
how to produce numbers from 1 to 10 using dual table