how can create the lexical parameter after the select class?
Answer / ashutosh
just create a parameter
and write sql command in report like this...
select * from emp
where &condition
| Is This Answer Correct ? | 9 Yes | 0 No |
What is a predefined exception available in forms 4.0?
When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?
What buil-in routines are used to display editor dynamicaly?
What is a Static Record Group?
LOV can best describe a) window b)modal c)list d) none of these d)
What built-in is used for showing the alert during run-time?
what is a package n what r the packages availbla in report
Can you truncate a table in a procedure in Oracle Forms?
Is it possible to split the printpreviewer into more than one region?
HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.
What is synchronize?
What is an oracle report? List its various types.