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
6269 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

all steps of bitmap report?

2394

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2329

i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame

3041

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

2181

What are the various configuration files that are used by oracle forms?

1071

How can we generate report output in excel format?

1036

What do you understand by lov?

1078

what are the oracle forms services components include?

1080

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

2024

What is the difference between flex mode and confined mode?

1101

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

1199

Explain how can you use the same lov for 2 columns?

1179

where do u put the report file

2133

what is difference between group above and group left report

3869

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1249