how to i write the query 'NISHI' TO
N
I
S
H
I
Answer Posted / 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 |
Post New Answer View All Answers
How to list all indexes in your schema?
Can a formula column referred to columns in higher group ?
Explain implicit cursor.
Why does oracle 9i treat an empty string as null?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How to filter out duplications in the returning rows using oracle?
What is the difference between substr and instr?
How to create a new oracle data file?
What is bulk copy or bcp in oracle?
What is dual table oracle?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
How to connect ms access to oracle servers?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to divide query output into groups in oracle?
How to use values from other tables in update statements using oracle?