How can you create Lexical parameter n Bind parameter in
Reports ?
Answer Posted / swarna.alizerla
we can create lexical parameter & bind parameter in the
report in the data model query.
The bind parameter is used as well and lexical parameter
used for ex:
select &deptno,ename,deptno from emp where empno=:empno
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is a canvas in oracle forms?
Why oracle forms required?
What do we mean by record group in oracle forms?
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
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
What is an SQL FORMS ?
how to send file attachment from oracle forms
what is tripstop report?
can you convert or reverse engineer a fmx back to a fmb file?
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
difference between global n context sensitive segments?
i am writing a query select EmpNo from Emp how can i call in after parameter form
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
How can we generate report output in excel format?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?