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 oracle database ? : Sql dba
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
How to make a copy values from one column to another in sql?
How does sql developer connect to oracle database?
What is the use of nvl function?
List different type of expressions with the example.
What is cascade in sql?
How many types of index are there?
What has stored procedures in sql?
Differentiate pl/sql and sql?
What is varchar data type in sql?
What is %rowtype in pl sql?
Can we use view in stored procedure?
What is auto increment feature in sql?
What is bitemporal narrowing?