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;

How remove data files before opening a database?

743

---

What is the difference between view and materialized view in Oracle?

826

---

Does oracle charge for java?

785

---

What is memory advisor in Oracle?

799

---

How to download oracle database 10g xe?

765

---

---

What is a synonym? What are its various types?

836

---

How to use "in out" parameter properly?

776

---

Is oracle the best database?

691

---

Explain constraining triggers.

820

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1661

---

What is data type in oracle?

753

---

WHAT IS ecc 6.0

1895

---

What are the tools for Oracle ?

787

---

What to do if the binary spfile is wrong for the default instance?

752

---

What is clustered table in Oracle?

826

---