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 do you find current date and time in oracle?

1062

---

What is meant by an index?

1155

---

Explain what are the different type of segments?

975

---

How many types of table in Oracle?

1134

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1054

---

How many memory layers are in the oracle shared pool?

1196

---

what are the default admin accounts in Oracle 10g ?

980

---

candidate key is subset of super key but not vice-verse explain

2074

---

What is raw datatype?

1148

---

How to assign a tablespace to a users in oracle?

1052

---

What is system tablespace?

1108

---

What is partitioned table in Oracle?

1200

---

what are bitmap indexes? How does they work?

2266

---

How to download oracle database 10g xe?

1026

---

Can we commit inside a function in oracle?

973

---