What is the use of place holder column?1 5493
How can a break order be created on a column in an existing group?1 2876
What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?1 3296
What is the use of break group?1 2716
How do you display console on a window ?1 2647
System.effective_date system variable is read only True/False1 3391
What is the use of hidden column?1 3041
What is the built-in used for showing lov at runtime?1 3245
What are the two types views available in the object navigator?1 3037
What are the two repeating frame always associated with matrix object?1 3263
If two groups are not linked in the data model editor, What is the hierarchy between them?1 5825
Why is a Where clause faster than a group filter or a format trigger?1 3335
What does the term panel refer to with regard to pages?1 2560
What is the difference when confine mode is on and when it is off?1 2941
Is it possible to have multiple layouts in a report?
What is an oracle report? List its various types.
how to send file attachment from oracle forms
What is a user exit program in oracle reports?
why the Ctl file u put only in bin folder why not in other folder
What is responsibility and how u attach How to create user and how u attach with responsibility.
what is the difference between call_form, new_form and open_form?
Can we invoke one form from another in a multi-forms application?
What do you understand by oracle forms and why are they required?
how do u compile a form i.e .fmb file in Unix or in dos
List out the oracle forms configuration files?
What is a matrix report and how many minimum groups are required to prepare the same?
i am writing a query select EmpNo from Emp how can i call in after parameter form
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
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