Answer Posted / shailesh
Yes u can write directly write a coomit; in any of the
report trigger.
e.g I have created a report and written in before report
trigger
update scott.emp set ename='SMITH_1' where ename
like 'SMITH';
commit;
It worked
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how report can be generated if we have the database designed in oracle 10g?
what is difference between group above and group left report
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
Is it possible to have multiple layouts in a report?
What is an oracle report? List its various types.
What are the various configuration files that are used by oracle forms?
Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables
if some data is not transfered where it will get stored
What do you understand by oracle forms?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
Explain master-detail relationship with some examples.
What is the difference between BPA AND Contract What are documents and test cases u followed
List the different types of columns in oracle reports.
What is an SQL FORMS ?