What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE
TRIGGERS ?
Answer Posted / guest
These triggers are executes when inserting,deleting and
updating operations are performed and can be used to
change the default function of insert,delete or update
respectively.
For Eg, instead of inserting a row in a table an
existing row can be updated in the same table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
Is it possible to have multiple layouts in a report?
List out the oracle forms configuration files?
if u want to delete all these detail block etc what will happen in form
how to send file attachment from oracle forms
What is the difference between bind and lexical parameter?
What do you understand by lov and how can it be used?
What is an oracle report? List its various types.
List the different types of columns in oracle reports.
Explain how can you use the same lov for 2 columns?
What is a matrix report and how many minimum groups are required to prepare the same?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
What is responsibility and how u attach How to create user and how u attach with responsibility.
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output
can you convert or reverse engineer a fmx back to a fmb file?