-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
What are triggers in database? ">
What are triggers in database?
The programmer may like the database o take some action when a database event occurs. In order to achieve the above purpose triggers are defined. The trigger body refers to the code written within the trigger which gets fired and executed when the related database event associated with the trigger occurs. On this situation one may have the question what is the event on the happening of which triggers...
-
What is the use of truncate command?
Truncate command will delete all records and the most important thing to make note of truncate command is since truncate command cannot be rolled back one must make sure to take proper backup of table data before performing the truncate command. Truncate command is thus used to remove all rows from either a table or a cluster. If one wants to use the truncate command in a cluster they can use it only...
-
Oracle Basics Interview Questions
Ans