Answer / Ram Hari Meena

Both subqueries and joins serve different purposes and there is no general rule that one is always better than the other. The choice depends on the specific situation, complexity of the query, and performance requirements.

Can we connect to postgresql using sql developer?

1 Answers  

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

How collections are improve the performance?

1 Answers   Polaris,

---

What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,

---

Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 Answers  

---

What is bind reference and how can it be created?

1 Answers  

---

Where the integrity constrints are stored in Data Dictionary?

1 Answers  

---

What is a sql trace file?

1 Answers  

---

What is sql prepared statement?

1 Answers  

---

How does sql profiler work?

1 Answers  

---

How does pl sql work?

1 Answers  

---

What is the difference between join and union.

27 Answers   3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,

---