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


Please Help Members By Posting Answers For Below Questions

What is a canvas in oracle forms?

828


Why oracle forms required?

816


What do we mean by record group in oracle forms?

853


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

1501


if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1716


What is an SQL FORMS ?

2540


how to send file attachment from oracle forms

2344


what is tripstop report?

1573


can you convert or reverse engineer a fmx back to a fmb file?

924


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

2733


difference between global n context sensitive segments?

2466


i am writing a query select EmpNo from Emp how can i call in after parameter form

1838


Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1801


How can we generate report output in excel format?

795


If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2085