 Related Questions Database trigger is stored PL/SQL program unit associated with a specific database table. Usages are Audit data modifications, Latest Answer : A database trigger is a named pl/sql block associated with a table and fires automatically when an event occurs or something happens. Data auditing , Implementing complex business rules, security are main uses of database triggers. ... What are advantages fo Stored Procedures / Extensibility,Modularity, Reusability, Maintainability and one time compilation. Data Concarency => Means that many users can access data at the same time.Data Consistency => Means that each user sees a consistent view of the data, including visible changes made by the user's Latest Answer : types of triggers ... Latest Answer : simple statement....beginselect sysdate from into A dual;dbms_ouput.put_line(A);end; ... Latest Answer : Alter table disable all trigger; ... Latest Answer : First execute "Set Timing on" Cammand on SQL Prompt and after that SQL> SET TIMING ON Execute the SQL Cammand on SQL PromptSelect * from Emp; You will get the time displayed. Like This-SQL> SELECT * FROM EMP; ... Read Answers (3) | Asked by : Mrigen if i am updating one record in a table at that time no other user can't able insert ,update the record in same table How is it possible Latest Answer : you can select the table for updationfor eg: select * from emp for update;no you can do the update/insert anything you want... any other user or session would be able to do any insert/update to the same table only after you release the table by commit ... Why we use instead of trigger. what is the basic structure of the instead of trigger. Explain specific business reason of it's use Latest Answer : Clustering is a method of storing tables that are intimately related and often joined together into the same area on disk. For example, instead of the BOOKSHELF table being in one section of the disk and the BOOKSHELF_AUTHOR table being somewhere else, ... Latest Answer : A CURSOR normally selects the records given by the query in a separate buffer
area and these fetched records will be referenced or make used in the program by
looping structures like FOR LOOP etc.
A REF CURSOR is used as a reference type. for Ex:- ... Read Answers (2) | Asked by : gouri sankar rath
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
