Explain what are program units and attached libraries? How do they differ from one another?
Latest Answer: The Difference is Program units are only to the corresponding form or report.If, you have written that code in attached library, you can use that code in multiple forms or reports - means reusability, where as you cannot reuse a program unit in multiple ...
What is the use of the placeholder column? Can placeholder column variable be used as global variable with in the report? Why?
Latest Answer: Place holder column is usesd to capture the bind variable in the query ...
In which circumstances you will use POST instead of commit?
Latest Answer: Posting is an event that writes insert update and delete in the form but not commiting these transaction to the data base. Commit is an event that attempts to make the data in the database identical to data in the form. ...
Latest Answer: Lexical parameters are used to substitute multiple values at runtime. It can be used in FROM TABLE NAME and in WHERE clause. Usually the lexical parameters are defined in After Parameter Report or in Before Report. For example:IF :P_DATE_FROM IS ...
Hi all,Pls answer the following questions1.what is the difference between CALL FORM,NEW FORM, & OPEN FORM?2.can a report contain more than one template?3.where will u define GLOBAL VARIABLES in Reports?
Latest Answer: Answer to the first Question is :CALL_FORM to run forms in modal mode. The calling form remains inactive till the called form is exited.NEW_FORM to close the calling form, and then invoke the called form.OPEN_FORM for interform navigation or interform ...
Latest Answer: After parameter Trigger: It will fire after the parameter form is displayed.here we can do validation on parameter valuesBefore Report Trigger: It will fire before the report is execured and after the query is parsed and date is fetched. ...
What is the process of Report customization? how can you customize the suite Report, after customizing ?
Latest Answer: When-validate-item,key-next-item ,on-error,on-message etc are the common triggers shared by form , block as well as items ...
If a report requires two parameter and one parameters list of values depend on another parameter, then how this will be done. What sort of things will be done to value set?
Latest Answer: Creating Oracle Forms Developer applications using Wizards Working with the enhanced user interface Ensuring consistency across applications Representing data within your application Understanding Oracle8 object features Working with Oracle8 object features ...
View page [1] 2 3 4 5 Next >>
Go Top
