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

Where is pl sql used?

904


What is pl sql script?

976


Show how functions and procedures are called in a pl/sql block.

1041


List and explain the different types of join clauses supported in ansi-standard sql?

1300


explain access control lists. : Sql dba

947


What are the types of keys?

931


i have some prob lem to tell me about my self in interview first round ...

2114


What are keys in sql?

944


How do I install microsoft sql?

981


Explain about various levels of constraint.

884


What is the purpose of cursors in pl/sql?

1078


What is clustered index in sql?

1001


What is benefit of creating memory optimized table?

907


What is a primary key sql?

990


How much does a sql dba make? : SQL DBA

889