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 t sql used for?

1017


What is trigger in pl sql with examples?

1049


Why stored procedure is faster than query?

1064


Mention what does the hierarchical profiler does?

1093


Why is %isopen always false for an implicit cursor?

1112


What is sql injection owasp?

1069


What is trigger in sql and its types?

1065


How to use transactions efficiently : transact sql

1060


What is execute immediate?

1088


What is procedure and function in sql?

1003


How many commands are there in sql?

1033


Are subqueries better than joins?

977


Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3572


how to write date and time literals? : Sql dba

965


How to know the last executed procedure?

1100