Answer / avi007

Statement level trigger is default.

Answer / vaibhavi_dixit

I think ,Default triggers in oracle are nothing but
Constraints.Constraints are the triggers which are executed
automatically at the time of DML operations.

Thanks
VD

Answer / ahmed

By default, a trigger is created in the enabled state.

Can two tables have same primary key?

0 Answers  

---

What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 Answers   TCS,

---

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  

---

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

---

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra

2 Answers   Zensar,

---

Types of locks in database ?

8 Answers   HCL, TCS, Tieto,

---

What is where clause in sql?

0 Answers  

---

what is rollback? : Sql dba

0 Answers  

---

What is sql in java?

0 Answers  

---

How do you remove duplicates without using distinct in sql?

0 Answers  

---

What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

5 Answers   Polaris,

---

How to create your own reports in sql developer?

0 Answers  

---