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
what is a package n what r the packages availbla in report
How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff
What do you understand by oracle forms?
from where do u receive the information to develop report
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output
if some data is not transfered where it will get stored
What is an oracle report?
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
Explain how can you use the same lov for 2 columns?
How can we expand Parameter Form Canvas on Reports 6i?
What do we mean by record group in oracle forms?
What is responsibility and how u attach How to create user and how u attach with responsibility.
what are the new features introduced in oracle form services in 11g release 2?
how report can be generated if we have the database designed in oracle 10g?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users