Answer / Priyanka Gangwar

The DUAL table in Oracle is a system-defined, single-row table that returns a dummy row containing an empty column. It has no columns explicitly defined and its purpose is mainly for testing SQL expressions.

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

1 Answers  

---

How to use "in out" parameter properly?

1 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?

1 Answers   Mastek,

---

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

1 Answers   Goldman Sachs,

---

Explain what are the different type of segments?

1 Answers  

---

difference between oracle8i and oracle9i

4 Answers   NIIT,

---

What is an Integrity Constrains ?

3 Answers  

---

What happens to indexes if you drop a table?

1 Answers  

---

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

1 Answers   HCL,

---

What is private procedure oracle?

1 Answers  

---

20. Using a set operator, display the client number of all clients who have never placed an order.

1 Answers   Wipro,

---

How to call a sub procedure?

1 Answers  

---