Answer / vijay

Statement level trigger is default trigger

Answer / ram

Before Insert/update/delete triggers executes first..
In this statement level triggers execute first..the order flows as below
Statement level -- before trigger
row level -- before trigger
row level -- after Insert/update/delete triggers
statement level -- after Insert/update/delete triggers

can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?

2 Answers   Fujitsu,

---

we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?

3 Answers   TCS,

---

what is definer rights invoke rights?

1 Answers  

---

What is a sql profiler?

0 Answers  

---

Can we join tables without foreign key?

0 Answers  

---

Mention what does plv msg allows you to do?

0 Answers  

---

explain commit and rollback in mysql : sql dba

0 Answers  

---

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,

---

how to find 5th row ?

10 Answers  

---

What is linq to sql?

0 Answers  

---

Can a varchar be a primary key?

0 Answers  

---

What is the difference between an inner and outer join?

0 Answers  

---