Answer Posted / nandkumar

There are bascis 3 difference between them
1> trigger invokes implicitly while we need to invoke
procedure explicitly.
2> We cant pass values from user to trigger but we can pass
values into procedure.
3> Trigger cant return value procedure can return value.

What operators deal with null?

1107

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

995

---

How does cross join work?

957

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1829

---

Define a temp table?

1017

---

which tcp/ip port does sql server run on? : Sql dba

1026

---

Does truncate require commit?

975

---

What are string functions in sql?

1241

---

tell me about various levels of constraint. : Sql dba

1035

---

How do you declare a constant?

960

---

how would you get the current date in mysql? : Sql dba

967

---

What is the limitation on the block size of pl/sql?

987

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1060

---

What is oracle pl sql developer?

981

---

What is a recursive join sql?

1072

---