Answer / kiran r

Triggers are classified as follows
1. Based on Trigger level
Row level Trigger and Statement level trigger
2. Based on time
Before, after, Instead
3. Based on Event
DDL, DML,Database Trigger

what is the command used to fetch first 5 characters of the string? : Sql dba

0 Answers  

---

How do I count rows in sql query?

0 Answers  

---

What are different types of joins ?

5 Answers   BirlaSoft,

---

What is the Difference between Procedure and Function.Can we call a Function in a DML?

2 Answers   TCS,

---

Its possible to add more than one primary key for the table

4 Answers  

---

What has stored procedures in sql and how we can use it?

0 Answers  

---

how can we optimize or increase the speed of a mysql select query? : Sql dba

0 Answers  

---

Which is faster union or join?

0 Answers  

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

0 Answers   Virtusa,

---

what is a foreign key ? : Sql dba

0 Answers  

---

What are the usages of sql?

0 Answers  

---

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---