Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions

1 Answers  

---

How to insert a new row into a table in oracle?

0 Answers  

---

What is mean by Program Global Area (PGA) ?

9 Answers   Bajaj,

---

What is oracle datasource?

0 Answers  

---

What are the differences between interval year to month and interval day to second?

0 Answers  

---

how can we write trigger in trigger???????? can we write one trigger on two table???

2 Answers   Value Labs,

---

1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records

1 Answers  

---

Explain alias?

0 Answers  

---

What are a query and state the different types of queries and their uses?

0 Answers  

---

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

3 Answers  

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

0 Answers   Mastek,

---

Give the Types of modules in a form?

1 Answers  

---