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 can you execute the user defined triggers in forms 3.0 ?

2 Answers  

---

did u received a single file or multiple files

0 Answers  

---

What package procedure used for invoke sql plus from sql forms ?

1 Answers  

---

Any attempt to navigate programatically to disabled form in a call_form stack is allowed?

1 Answers  

---

Can we use bulk collect in oracle forms if yes then how?

1 Answers  

---

how to pass 2 variables from one form to other form

2 Answers   Intelligroup,

---

Does a Before form trigger fire when the parameter form is suppressed.

2 Answers  

---

Is it possible to attach same library to more than one form?

1 Answers  

---

what ia an object groups?

1 Answers  

---

what u write in Ctl file

2 Answers  

---

Table 1: STUDIES PNAME (VARCHAR), SPLACE (VARCHAR), COURSE (VARCHAR), CCOST (NUMBER) Table 2: SOFTWARE PNAME (VARCHAR), TITLE (VARCHAR), DEVIN (VARCHAR), SCOST (NUMBER), DCOST (NUMBER), SOLD (NUMBER) Table 3: PROGRAMMER PNAME (VARCHAR), DOB (DATE), DOJ (DATE), SEX (CHAR), PROF1 (VARCHAR), PROF2 (VARCHAR), SAL (NUMBER) PNAME – Programmer Name, SPLACE – Study Place, CCOST – Course Cost, DEVIN – Language the software or package is developed in, SCOST – Software Cost, DCOST – Development Cost, PROF1 – Proficiency 1 Use the above table definitions to answer the questions that follow. Find out the selling cost average for packages developed in Oracle. Display the names, ages and experiences of all programmers How much revenue has been earned through

1 Answers   Azri Solutions,

---

How can I sum column wise in Oracle excel report?

1 Answers  

---