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...

What are two virtual tables available during database
trigger execution ?

Answer Posted / tulsi

The table columns are referred as OLD.column_name and
NEW.column_name.
For triggers related to INSERT only NEW.column_name values
only available.
For triggers related to UPDATE only OLD.column_name
NEW.column_name values only available.
For triggers related to DELETE only OLD.column_name values
only available

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is auto increment feature in sql?

1116


What is t sql used for?

1010


What is sql injection vulnerability?

937


what are date and time data types? : Sql dba

976


Why commit is not used in triggers?

1033


How can you save or place your msg in a table?

999


what is a field in a database ? : Sql dba

1049


What types of commands can be executed in sql*plus?

1101


what is 'mysqlcheck'? : Sql dba

1004


What are sql procedures?

1016


What are the operators in sql?

1017


Which is better varchar or nvarchar?

990


What is numeric function sql?

1049


What are the types of variables use in pl sql?

1033


Does sap use sql?

970