we cant use tcl commands in trigger,,, if we call procedure in trigger the

IF i write before / after insert / update trigger and i do
rollback what will happen?

Question Posted / abhijit

Answer Posted / abhijit

we cant use tcl commands in trigger,,,
if we call procedure in trigger then we can use pragma autonomous transaction for tcl

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How are sql commands classified?

1038

What is the difference between a query and a report?

903

how to create a new table by selecting rows from another table in mysql? : Sql dba

1011

How to start oracle sql developer?

986

how to convert character strings to dates? : Sql dba

985

How do you optimize a query?

941

Is like operator in sql case sensitive?

962

What is the least restrictive isolation level? : Transact sql

998

How many disk partitions should I have?

942

what is user defined functions? : Sql dba

977

What does seeding a database mean?

895

How many triggers can be applied on a table?

882

Can variables be used in sql statements?

982

Is sql open source?

917

What is difference between nchar and nvarchar?

958