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
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
what is the functionality of the function htmlentities? : Sql dba
Mention what are the benefits of pl/sql packages?
How can we optimize a sql query?
What is linq to sql?
What is the difference between database trigger and stored procedure?
How do you change a value in sql?
What is cartesian join in sql?
What is the function that is used to transfer a pl/sql table log to a database table?
Can you load data into multiple tables at once? : aql loader
What are inner outer left and right joins in sql?
Why join is faster than subquery?
What is difference between left and right outer join?
How do I truncate a word?
What is the starting oracle error number?