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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What are two virtual tables available during database
trigger execution ?

Question Posted / tulsi

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

Why use subqueries instead of joins?

1036

what is heap table? : Sql dba

1054

What are system versioned tables?

976

What is nested table in pl sql?

1011

How do I write a sql query in pgadmin 4?

932

What is sql clause?

1002

Is sqlite thread safe?

998

How do I view an execution plan in sql?

928

Mention what pl/sql package consists of?

945

Is it possible for a table to have more than one foreign key?

989

How do I get sql certification?

931

What is sql dialect?

1047

Explain scalar functions in sql?

1026

what is the difference between delete and truncate statement in sql? : Sql dba

1145

What are different types of queries in sql?

1056