Answer / anil kumar karasi

Lexical parameter is a condition (where clause) given at
runtime to generate the report on that condition. The '&'
symbol will preceed the where clause condition.

Answer / deepak muduli

Lexical parameters can dynamically replace clauses in the
Select statement in the data model and even the whole
select statement. It replaces any part of a SELECT
statement, such as column names, the FROM clause, the WHERE
clause, the ORDER BY clause. To create a lexical reference
in a query, prefix the parameter name with an ampersand (&)

how report can be generated if we have the database designed in oracle 10g?

1 Answers  

---

How can we expand Parameter Form Canvas on Reports 6i?

0 Answers   ABB,

---

What is a Non Query Record Group?

1 Answers  

---

What is the difference between NAME_IN and COPY ?

2 Answers  

---

What are the three types of user exits available ?

1 Answers  

---

what is the difference between call_form, new_form and open_form?

0 Answers  

---

What do you understand by lov?

0 Answers  

---

What is a record group?

1 Answers  

---

Please tell me what is wrong in the below query: (Very Urgent) ================================================= function BeforePForm return boolean is begin if :from_invoice_date is null OR :to_invoice_date is null then aiv.PERIOD_NMAE:=:gl_period elsif :gl_period is null then aiv.INVOICE_DATE between :from_invoice_date and :to_invoice_date end if; return (TRUE); end;

2 Answers   TCS,

---

How can I sum column wise in Oracle excel report?

1 Answers  

---

What are the different types of Delete details we can establish in Master-Details?

1 Answers  

---

List the buil-in routine for controlling window during run-time?

1 Answers  

---