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
explain about mysql and its features. : Sql dba
Can function return multiple values in sql?
What are actual parameters and formal parameters?
What are the types of views in sql?
what are the advantages and disadvantages of views in a database? : Sql dba
How do I edit a stored procedure?
How to place comments in pl/sql?
write an sql query to find names of employee start with 'a'? : Sql dba
How do you pronounce sql?
what is acid property in database? : Sql dba
what are the non-standard sql commands supported by 'mysql'? : Sql dba
What is the use of sqlerrd 3?
What has stored procedures in sql?
What is a clob in sql?
Does sql backup shrink transaction log?