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
Is it possible to execute a dynamic sql from forms?
what is oracle forms?
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
Explain master-detail relationship with some examples.
What do you understand by lov?
How can we expand Parameter Form Canvas on Reports 6i?
Can we invoke one form from another in a multi-forms application?
what are the new features introduced in oracle form services in 11g release 2?
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
how do u compile a form i.e .fmb file in Unix or in dos
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...
Is it possible to have multiple layouts in a report?
i am writing a query select EmpNo from Emp how can i call in after parameter form
how do u place it in required folder