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
No Answer is Posted For this Question
Be the First to Post Answer
What are the display styles of an alert?
How can a cross product be created?
What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?
What is the remove on exit property?
What package procedure is used for calling another form ?
What do you understand by oracle forms and why are they required?
What is a master detail relationship?
What are the Built-ins to display the user-named editor?
What is a Package Procedure ?
What is the difference between system.current_field and system.cursor_field ?
What is an User_exit?
Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?