Answer Posted / lreddy
NO, IN Before Report Trigger we can use SRW.DO_SQL to
perform any DDL Operations.
For DDL Operations are internal commit.
so no need to use Commit statement in Before Reprot Trigger.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the various configuration files that are used by oracle forms?
i am writing a query select EmpNo from Emp how can i call in after parameter form
if u want to delete all these detail block etc what will happen in form
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
In what sequence do triggers get fired by oracle forms?
Name the different triggers associated with oracle forms having a master-detail relationship.
what is difference between group above and group left report
What is the difference between flex mode and confined mode?
what are bind variables?
hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...
difference between global n context sensitive segments?
if some data is not transfered where it will get stored
what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?
Explain the different levels at which oracle form services interact.
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE