What happens if a procedure that updates a column of table X
is called in a database trigger of the same table ?

Answer Posted / tulsi

Mutation of table occurs.

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is 'mysqladmin' in mysql? : Sql dba

744


Explain the savepoint statement.

811


What are tables and fields?

761


What is trigger and how to use it in sql?

723


name 3 ways to get an accurate count of the number of records in a table? : Sql dba

787






What are the sql versions?

672


What are the possible values that can be stored in a boolean data field?

715


Why we use joins in sql?

723


What are the different tcl commands in sql?

815


How do you update a value in sql?

717


Can we use the cursor's to create the collection in PL/SQL?

694


Can a select statement fire a trigger?

885


Why do we use cursors?

667


Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

774


what is the command used to fetch first 5 characters of the string? : Sql dba

1365