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

what is sql profiler

2 Answers   Fidelity,

---

What company owns postgresql?

0 Answers  

---

Can you skip header records while loading? : aql loader

0 Answers  

---

What is ttitle and btitle?

0 Answers  

---

what are date and time functions in mysql? : Sql dba

0 Answers  

---

What is primary and foreign key?

0 Answers  

---

What is function and procedure in pl sql?

0 Answers  

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

What are primary key and foreign key and how they work?

0 Answers  

---

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

4 Answers   Cap Gemini, MTS,

---

What is the use of triggers?

0 Answers  

---

how can i read write files from pl/sql

3 Answers  

---