How can you create Lexical parameter n Bind parameter in
Reports ?
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 |
What is lexical reference?How can it be created?
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
What is the difference between NAME_IN and COPY ?
How can a break order be created on a column in an existing group?
What are the two panes that Appear in the design time pl/sql ?
how to hide the scroll bar in forms 6i
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
What is a library?
What is an Invoice ? How many types of invoices are there in AP and AR ?
I developed on form as per my requirement,and register that one in apps custom_top.But the problem is ,if you open the form but not closed,I founded why this is error is comming ,the custom_top is not supported my form . I need any one your help in advicing me...what I do the custom_top supported the forms.
At what point of report execution is the before Report trigger fired?
Give the sequence of execution of the various report triggers?