How can you create Lexical parameter n Bind parameter in
Reports ?
Answer Posted / swarna.alizerla
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 |
Post New Answer View All Answers
how do u place it in required folder
what is the difference between call_form, new_form and open_form?
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
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
What do you understand by oracle forms?
In what sequence do triggers get fired by oracle forms?
List out the oracle forms configuration files?
did u received a single file or multiple files
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
if u want to delete all these detail block etc what will happen in form
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
if some data is not transfered where it will get stored
Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.
What is the difference between BPA AND Contract What are documents and test cases u followed
what is oracle forms?