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 the use of constraints option in exp command.

1048

---

What happens to indexes if you drop a table?

1169

---

How do I start tns listener?

1044

---

What is rowid and rownum in oracle?

1011

---

What are the restrictions in a oracle read only transaction?

1034

---

What is a nvl function?

1032

---

What is the difference between substr and instr?

1037

---

Is a rollback possible to any savepoint?

1095

---

Is primary key indexed by default in oracle?

987

---

What are the logical operations?

1125

---

What is rich query?

981

---

How to connect to a remote server?

1125

---

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

1857

---

What privilege is needed for a user to delete rows from tables in another schema?

1067

---

How to define and use table alias names in oracle?

943

---