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;

Explain about achiever in sql?

1086

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2266

---

What is proxy method?

1020

---

How many types of synonyms in Oracle?

1175

---

What is logical backup in oracle?

1081

---

Please explain compound trigger in oracle?

1107

---

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1124

---

Explain the use of compress option in exp command.

1066

---

How to start a new transaction in oracle?

1134

---

What are the different oracle database objects?

1145

---

Why does oracle 9i treat an empty string as null?

1124

---

How to drop a stored procedure in oracle?

1102

---

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1788

---

Where do we use decode and case statements?

1059

---

How many types of database triggers exist?

1184

---