Answer / Smriti Maddheshiya

Yes, in both SQL and PLSQL, triggers can call stored procedures to perform complex operations when an event occurs.

Can you join a table to itself?

1 Answers  

---

write a query to delete similar records in different tables with same structure

4 Answers  

---

Why sql query is slow?

1 Answers  

---

Write the command to remove all players named sachin from the players table.

1 Answers  

---

What is a composite primary key?

1 Answers  

---

Which language is used in sql?

1 Answers  

---

How to call the function and Procedure in trigger?

3 Answers   IBM,

---

What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 Answers   TCS,

---

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

---

How can we optimize a sql query?

1 Answers  

---

What is sql partition?

1 Answers  

---

What is recursive join in sql?

1 Answers  

---