Oracle Interview Questions And Answers

Computer Tutorials Earn Money From Internet Cheap Freelancers Ask An Expert Register Cheap Domain Data Recovery Best Mutual Funds Trading Forex Online Cheap Web Hosting Ajax Tutorials Cheap Cell Phone Plans Free Mobile Learning Job Portal Photoshop Tutorials Cheap Jewelry Cheapest Air Travel

Oracle Interview Questions And Answers Page 61 of 95 69. How do you call other Oracle Products from Oracle Forms? Run_product is a built-in, Used to invoke one of the supported oracle tools products and specifies the name of the document or module to be run. If the called product is unavailable at the time of the call, Oracle Forms returns a message to the opertor. 70. How do you reference a Parameter? In Pl/Sql, You can reference and set the values of form parameters using bind variables syntax. Ex. PARAMETER name = '' or :block.item = PARAMETER Parameter name 71. How do you reference a parameter indirectly? To indirectly reference a parameter use the NAME IN, COPY 'built- ins to indirectly set and reference the parameters value' Example name_in ('capital parameter my param'), Copy ('SURESH','Parameter my_param') 72. What are the different Parameter types? Text Parameters Data Parameters 73. When do you use data parameter type? When the value of a data parameter being passed to a called product is always the name of the record group defined in the current form. Data parameters are used to pass data to produts invoked with the run_product built-in subprogram. 74. Can you pass data parametrs to forms? No. IMAGES 75. What are different types of images? Boiler plate images Image Items 76. What is the difference between boiler plat images and image items? Boiler plate Images are static images (Either vector or bit map) that you import from the file system or database to use a grapical elements in your form, such as company logos and maps Image items are special types of interface controls that store and display either vector or bitmap images. Llike other items that store values, image items can be either base table items(items that relate directly to database columns) or control items. The definition of an image item is stored as part of the form module FMB and FMX files, but no image file is actualy associated with an image item until the item is populate at run time.