Answer Posted / sandeep chawdekar

there are mainily 3 types of triggers
1> dml trigger
2>instead of trigger written on only view
3>system trigger

dml trigger written on table that gets fired on dml events
like
insert or delete or update operation
that trigger may fire
1>after dml event
2> before dml event these are timings for trigger firing

instead of trigger written only on view that view is not
modifiable that also gets fired
when dml event occurs

system trigger gets fired on system event like
before log off or after log on or before shutdown
this trigger may be written on
database level
schema level

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2556

---

What is the difference between function, procedure and package in pl/sql?

1355

---

differentiate between float and double. : Sql dba

1110

---

Explain ttitle and btitle.

1165

---

Can you upgrade sql express to full sql?

1144

---

How can get second highest salary in sql?

1028

---

Why do we use function in pl sql?

1114

---

What is scope and visibility in PL/SQL?

1291

---

Is sql difficult?

1229

---

What is t sql in sql server?

1132

---

how to convert numeric values to character strings? : Sql dba

1162

---

how does a local variable is defined using t-sql? : Transact sql

1061

---

what is commit? : Sql dba

1127

---

How do I get sql certification?

1018

---

How do I run a script in sql developer?

1000

---