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
What is rownum and rowid?
What are the methods of filing?
How long does it take to learn pl sql?
How to pronounce postgresql?
What is string join?
What is the sql*loader? : aql loader
what are the types of join and explain each? : Sql dba
what is 'mysqlimport'? : Sql dba
Explain what is sql*plus?
what is the command line end user interface - mysql? : Sql dba
Is sqlite thread safe?
Explain how to use transactions efficiently : transact sql
What are the operators used in select statements?
What are stuff and replace function?
what is union, minus and interact commands? : Sql dba