Answer / k. a. purushotham

Basically there are three types of triggers,

Row and statement triggers
Before and after triggers
Insteadof triggers

Possible combination of these triggers
Before row trigger
After row trigger
Before statement trigger
After statement trigger

Instead of trigger is mainly for a view.
if we want to write a trigger in such a way that the
trigger action is to be on underlying base tables of a view,
when an DML statement (insert,update,delete)is issued

Answer / rakesh n

1) Action
2) Event
3) Condition

Answer / pratap

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

Answer / dev

static trigger
the icon or window background is clicked or double-clicked
without moving the mouse

dynamic trigger
the icon is dragged and dropped onto another icon or window
background

hold trigger
the mouse button is held down on an icon or window background

What is JDBC and ODBC and what are the differences between them?

11 Answers   Idbi Bank, Infosys, Infoview, TCS,

---

What is the purpose of jdbc?

0 Answers  

---

What are restrictions on triggers?

0 Answers  

---

is java pure object oriented or not ?

7 Answers  

---

How to find that, a row is updated or not?

2 Answers  

---

What is the equivalent method for precompiled SQL Statement in JDBC?

1 Answers  

---

Give an example for getXXX method?

0 Answers  

---

How many categories of jdbc drivers are there?

0 Answers  

---

java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDr iver? I get this error at run time.I used oracle10G. I set CLASS PATH:C:\oraclexe\app\oracle\product\10.2.0 \server\jdbc\lib\ojdbc14.jar; I write JDBC PROGRAM like import java.sql.*; class Example { public static void main(String args[]) { try { Class.forName ("oracle.jdbc.driver.OracleDriver"); System.out.println("Driver Loaded"); Connection con=DriverManager.getConnection ("jdbc:oracle:thin:@localhost:1521:xe","system","salmas"); System.out.println("Driver Connected"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from emp"); while(rs.next()) { System.out.println(rs.getInt(1)); System.out.println(rs.getString(2)); System.out.println(rs.getString(3)); } st.close(); con.close(); } catch(Exception e) { System.out.println(e); } finally { System.out.println("it's finally block executed"); } } }

6 Answers   CTS,

---

What is a jdbc connection?

0 Answers  

---

What is the use of jdbc?

0 Answers  

---

What is the difference between jdbc and jndi?

0 Answers  

---