Answer / Megha Sharma

Joining tables directly (using JOIN statements) can be faster than using subqueries because the database engine only needs to execute a single query to retrieve the required data. In contrast, subqueries require multiple queries to be executed sequentially, which can increase processing time.

Explain constraints in sql?

1 Answers  

---

What is a trigger in pl/sql?

1 Answers  

---

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

2 Answers   Fintellix,

---

What is procedure explain with example?

1 Answers  

---

Does sqlite need a server?

1 Answers  

---

Can we alter stored procedure?

1 Answers  

---

what is msql? : Sql dba

1 Answers  

---

Why is %isopen always false for an implicit cursor?

1 Answers  

---

What are the parts of a basic sql query?

1 Answers  

---

What is normalization and types of normalization?

22 Answers   Etisbew, F-TEC, Microsoft, TechProcess,

---

Why is a trigger used?

1 Answers  

---

What are the ways on commenting in a pl/sql code?

1 Answers  

---