in user parameter property we have list of values.can we
write select query for binding? for example:: select empno
from emp where deptno=:deptnum :deptnum is first parameter
it displays distinct dept nos. if i do like this it is
giving error:: bind variables are not allowed in the select
statement
- 0 Answers
- 1696 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is system.coordination_operation?
What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?
What built-in is used for showing the alert during run-time?
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;
what are bind variables?
What are the important difference between property clause and visual attributes?
What are the various configuration files that are used by oracle forms?
What is AppCore and AppCore2 ?
What is the difference between BPA AND Contract What are documents and test cases u followed
where do u put the report file
Does a Before form trigger fire when the parameter form is suppressed.
What is the "LOV of Validation" Property of an item? What is the use of it?
Oracle General 
