Answer Posted / harinath yadav

Schema is a structure of xml that is list of element and
attribute.

How to define a variable of a specific record type?

1017

---

What is a cognitive schema?

905

---

When do you get a .pll extension in oracle?

1077

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1006

---

Can you tell me how to add new column in existing views?how?How is possible?

1370

---

What is a trigger and what are its types?

1113

---

What happens if variable names collide with table/column names?

1101

---

What is oracle database 10g express edition?

1070

---

How will you differentiate between varchar & varchar2?

991

---

What happens if recursive calls get out of control?

998

---

What is materialized view in Oracle?

1042

---

How do I spool in oracle?

939

---

What is using clause and give example?

997

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

965

---

What is the data type of dual table?

919

---