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;

does the query needs a hint to access a materialized view?

1817

---

Explain the use of record length option in exp command.

1026

---

What is pragma autonomous transaction in oracle?

993

---

How to use windows user to connect to the server?

936

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2211

---

What is program global area (pga) in oracle?

960

---

What is the parameter mode that can be passed to a procedure?

981

---

What to do if the startbd.bat failed to start the xe instance?

1017

---

What is oracle datasource?

926

---

Explain the importance of .pll extension in oracle?

956

---

How do I reset a sequence in oracle?

1052

---

Explain the use of indexes option in exp command.

1066

---

How to turn on or off recycle bin for the instance?

1012

---

What are the differences between char and varchar2 in oracle?

1076

---

How does oracle handle read consistency?

1052

---