how can create the lexical parameter after the select class?
Answer Posted / ashutosh
just create a parameter
and write sql command in report like this...
select * from emp
where &condition
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
if u want to delete all these detail block etc what will happen in form
I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object
What are the various configuration files that are used by oracle 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
hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...
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 ?
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
can you convert or reverse engineer a fmx back to a fmb file?
Name the different triggers associated with oracle forms having a master-detail relationship.
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.
List the different types of columns in oracle reports.
In what sequence do triggers get fired by oracle forms?
did u received a single file or multiple files
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
Is it possible to execute a dynamic sql from forms?