what is the difference between trigger and storedprocedures

Answer Posted / nagapawan

i want tell u that in 1)oracle- sql & pl/sql
2) sql server - sql & T-sql

all r giving the same answers to both , some difference
r there. for example writing a code different in oracle and
sql
server. in oracle- sql & pl/sql we can write big statements
and in sql server - sql & T-sql small statements ie,code.
ok . keep rememeber while answering it, wheather it is
oracle r sql server we r answering.
i have knowledge in both - oracle & sql server.

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is group function in sql?

535


How many clustered indexes can you have?

532


How do I view a procedure in sql?

547


What is scope and visibility in PL/SQL?

596


Can we have two clustered index on a table?

564






How to select random rows from a table?

519


What are the features of pl sql?

560


What is the main reason behind using an index?

554


What is right join sql?

535


Is inner join same as self join?

579


What are reports usually used for?

565


What is the difference between subquery and correlated query?

529


How do you update sql?

522


What is denormalization in a database?

592


What is dcl in sql?

528