Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how instead of triger is helpful for mutating tables errors
handlling ?

Answer Posted / mahesh

create a view (simple view) on mutating table

write a tigger on view (define similar to table)


Know try to do dml operations on table

it will not show the mutating error

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do foreign keys improve performance?

965


What is denormalization in a database?

994


can a stored procedure call itself or recursive stored procedure? : Sql dba

956


what is a control file ? : Sql dba

988


How many sectors are in a partition?

1032


how to rename an existing table in mysql? : Sql dba

1005


Why is a primary key important?

967


Can I learn sql in a week?

1005


What does trigger mean in slang?

1004


Can we enter data in a table in design view?

911


What's the difference between inner join and left join?

947


What is int identity in sql?

1060


What will you get by the cursor attribute sql%found?

899


What is sql*loader?

1073


Can we use loop in sql?

922