we can create lexical parameter & bind parameter in the report in the

How can you create Lexical parameter n Bind parameter in
Reports ?

Question Posted / swarna.alizerla

1 Answers
6186 Views
GE, SVSS, I also Faced
E-Mail Answers

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

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

2986

I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

2990

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1288

List out the oracle forms configuration files?

1067

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

2015

What do we mean by record group in oracle forms?

1066

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

2324

Why oracle forms required?

1027

Explain the various types of oracle report?

1068

How to create Drill down report?

2123

What is a matrix report and how many minimum groups are required to prepare the same?

1130

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

1009

In workflow how can we send a notification to the Supplier giving the Corresponding report Details.