i am writing a query select EmpNo from Emp how can i call in
after parameter form



i am writing a query select EmpNo from Emp how can i call in after parameter form..

Answer / Bhajan Veer Singh

To call a SQL query in an After Parameter form, you need to create a new block with the cursor that contains your query. Then, use the Open_cursor procedure to execute the cursor and assign its results to a variable or control.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Forms Reports Interview Questions

What is the difference when confine mode is on and when it is off?

1 Answers  


What is forms_DDL?

2 Answers  


What is an LOV?

2 Answers  


what are difference between post database commit and post-form commit?

2 Answers  


what is the use of between page trigers in REPORTS... (please give answer in a explanatory way...if possible give screen shots also...)

1 Answers  


What is the frame & repeating frame?

1 Answers  


How can we expand Parameter Form Canvas on Reports 6i?

1 Answers   ABB,


if u develop report do u ask for anything from u r team leader

1 Answers  


where do u put the report file

1 Answers  


What is the maximum size of a form ?

1 Answers  


How can a break order be created on a column in an existing group?

1 Answers  


what is procedure like symbols of bind and lexical

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • 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)