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 sql and also describe types of sql statements?

558


What is the difference between partitioning and sharding?

523


Enlist the data types that can be used in pl/sql?

567


What is a variable in sql?

510


What are instead of triggers?

615






What are inner and outer joins examples of both?

494


How do you go back in sql?

526


What are different functions in sql?

509


What is group function in sql?

525


Could you please provide oca (oracle 10g) dumps for my certification ?

4504


What is procedure and function in sql?

526


What is sqlite used for?

521


How to use sql*plus built-in timers?

572


How do I remove sql plus from windows 10?

562


Name the operator which is used in the query for pattern matching?

501