Can you mention lexical parameter in select statement in the
data model?

Answer Posted / dinesh mohan upadhyay

yes we mentin laxical parameter in select statement by
using &parameter in where condition

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the different levels at which oracle form services interact.

599


I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

841


How to create Drill down report?

1692


What is a canvas in oracle forms?

586


did u p prepared complex report

1599






if u want to delete all these detail block etc what will happen in form

1471


can you convert or reverse engineer a fmx back to a fmb file?

701


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

1287


What is a user exit program in oracle reports?

569


Is it possible to have multiple layouts in a report?

569


How can we generate report output in excel format?

550


how do u place it in required folder

1470


Name the different triggers associated with oracle forms having a master-detail relationship.

496


What is a matrix report and how many minimum groups are required to prepare the same?

548


did u received a single file or multiple files

1608