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
Show code of a cursor for loop.
how can we repair a mysql table? : Sql dba
What are character functions?
explain normalization concept? : Sql dba
Explain foreign key in sql?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
what are integrity rules?
What are the types of index in sql?
What is record variable?
What is the use of stored procedures?
How do I sort a table in sql?
What does the acronym acid stand for in database management?
How to run sql statements with oracle sql developer?
How do I count rows in sql?
What is difference between inner join and cross join?