What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE
TRIGGERS ?
- 1 Answers
- 3773 Views
- I also Faced
- E-Mail Answers
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
How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff
What is an SQL FORMS ?
what is oracle forms?
What is an oracle report? List its various types.
how do u place it in required folder
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
How to create Drill down report?
how to send file attachment from oracle forms
List out the oracle forms configuration files?
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
can you convert or reverse engineer a fmx back to a fmb file?
In what sequence do triggers get fired by oracle forms?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
What is the difference between flex mode and confined mode?
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
