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 |
What is difference between a formal and an actual parameter?
What is the oracle implicit cursor?
What to do if the startbd.bat failed to start the xe instance?
where we have to use ON clause and where we have to use USING clause in JOINS
Explain oracle insert into command?
In Oracle 10g, "g" Stands for what?
How many categories of data types in oracle?
How to load data through external tables?
Explain about achiever in sql?
How to define a variable to match a table column data type?
How do I connect to oracle database?
a query to select maxmun 3 salaries of employee table