Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / deepak muduli
Lexical parameters can dynamically replace clauses in the
Select statement in the data model and even the whole
select statement. It replaces any part of a SELECT
statement, such as column names, the FROM clause, the WHERE
clause, the ORDER BY clause. To create a lexical reference
in a query, prefix the parameter name with an ampersand (&)
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
Is it possible to execute a dynamic sql from forms?
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables
What do you understand by oracle forms and why are they required?
What is a canvas in oracle forms?
What do you understand by lov?
what are the oracle forms services components include?
how do u place it in required folder
did u received a single file or multiple files
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
What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?
How to create Drill down report?
In what sequence do triggers get fired by oracle forms?
did u p prepared complex report
how to send file attachment from oracle forms
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
