How do u give the list of values in bind parameter



How do u give the list of values in bind parameter..

Answer / vetrikumaran

GO TO THE PROPERTY PALLETE OF USER DEFINED PARAMETER AND
SELECT THE PROPERTY AS LIST OF VALUES..

THEN IT SHOWS STATIC AND SELECT..SELECT THE SELECT OPTION
AND WRITE THE QUERY..NOW IN THE OUTPUT,WE CAN FIND THE LIST
OF PARAMETER VALUES..

USER WILL SELECT THE VALUES ONLY FROM LOV.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Oracle Forms Reports Interview Questions

Error_Code is a package proecdure ?

1 Answers  


How is link tool operation different between reports 2 & 2.5?

1 Answers  


i want print character reports in 10g application reports pl help me my id is yoga.roh@gmail.com

3 Answers  


What are the default parameter that appear at run time in the parameter screen?

1 Answers  


Commited block sometimes refer to a BASE TABLE ? True or False.

1 Answers  






what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

0 Answers  


Hi...... I created a report which is geneated in .txt format. What I do for this is 1.First I change the system parameter mode to character in the report. 2.Then I place a button in my form to call the report. code in the button is as follows.. DECLARE rePid REPORT_OBJECT; rep_hndl VARCHAR2(100); BEGIN rePid := Find_Report_Object('reptxt.rdf'); Set_Report_Object_Property(rePid,Report_deStype,FILE); Set_Report_Object_Property(rePid,Report_FileName,'d:\sasi\reports\reptxt.rdf'); Set_Report_Object_Property(rePid,Report_desName,'d:\sasi\output\repprint.txt'); rep_hndl := Run_Report_Object(rePid); END; and it is working.. Now the problam is that when I preview the report from the report builder, it is in the format I needed. But when I run the form and run the report,Its alligment is not correct. Regards abc

1 Answers  


What are the two ways to incorporate images into a oracle forms application?

1 Answers  


In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

0 Answers  


how we can validate the run-time parameters in reports 6i

1 Answers   Satyam,


What are the two ways by which data can be generated for a parameter's Using static values?

1 Answers  


What is the difference between BPA AND Contract What are documents and test cases u followed

0 Answers   Zensar,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)