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
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
How can we generate report output in excel format?
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
Name the different triggers associated with oracle forms having a master-detail relationship.
What is the difference between bind and lexical parameter?
what are bind variables?
how to send file attachment from oracle forms
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
In what sequence do triggers get fired by oracle forms?
a text item is there what r the different types of triggers associated with it
What is an SQL FORMS ?
What is an oracle report?
if u want to delete all these detail block etc what will happen in form
i am writing a query select EmpNo from Emp how can i call in after parameter form