Oracle FAQ's Part-5

151. 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')

152. What is a timer?
Timer is an "internal time clock" that you can programmatically create to perform an action each time the times.

153. What are the two phases of block coordination?
There are two phases of block coordination: the clear phase and the population phase. During, the clear phase, Oracle Forms navigates internally to the detail block and flushes the obsolete detail
records. During the population phase, Oracle Forms issues a SELECT statement to repopulate the detail block with detail records associated with the new master record. These operations are
accomplished through the execution of triggers.

154. What are Most Common types of Complex master-detail relationships?
There are three most common types of complex master-detail relationships:
master with dependent details
master with independent details
detail with two masters

155. What is a text list?
The text list style list item appears as a rectangular box which displays the fixed number of values. When the text list contains values that can not be displayed, a vertical scroll bar appears,
allowing the operator to view and select undisplayed values.

156. What is term?
The term is terminal definition file that describes the terminal form which you are using r20run.

157. What is use of term?
The term file which key is correspond to which oracle report functions.

158. What is pop list?
The pop list style list item appears initially as a single field (similar to a text item field). When the operator selects the list icon, a list of available choices appears.

159. What is the maximum no of chars the parameter can store?
The maximum no of chars the parameter can store is only valid for char parameters, which can be upto 64K. No parameters default to 23Bytes and Date parameter default to 7Bytes.

160. What are the default extensions of the files created by library module?
The default file extensions indicate the library module type and storage format .pll - pl/sql library module binary

161. What are the Coordination Properties in a Master-Detail relationship?
The coordination properties are
Deferred
Auto-Query
These Properties determine when the population phase of block coordination should occur.

162. How do you display console on a window ?
The console includes the status line and message line, and is displayed at the bottom of the window to which it is assigned.To specify that the console should be displayed, set the console window
form property to the name of any window in the form. To include the console, set console window to Null.

163. What are the different Parameter types?
Text ParametersData Parameters

164. State any three mouse events system variables?
System.mouse_button_pressedSystem.mouse_button_shift

165. What are the types of calculated columns available?
Summary, Formula, Placeholder column.

166. Explain about stacked canvas views?
Stacked canvas view is displayed in a window on top of, or "stacked" on the content canvas view assigned to that same window. Stacked canvas views obscure some part of the underlying content canvas view, and or often shown and hidden programmatically.

167. What are the built_ins used the display the LOV?
Show_lov
List_values

168. What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?
Show editor is the generic built-in which accepts any editor name and takes some input string and returns modified output string. Where as the edit_textitem built-in needs the input focus to be in
the text item before the built-in is executed.

169. What are the built-ins that are used to Attach an LOV programmatically to an item?
set_item_property
get_item_property
(by setting the LOV_NAME property)

170. 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 operator.

171. What is the main diff. bet. Reports 2.0 & Reports 2.5?
Report 2.5 is object oriented.

172. What are the different file extensions that are created by oracle reports?
Rep file and Rdf file.

173. What is strip sources generate options?
Removes the source code from the library file and generates a library files that contains only pcode. The resulting file can be used for final deployment, but can not be subsequently edited in the
designer.ex. f45gen module=old_lib.pll userid=scott/tiger strip_source YES output_file

176. What is the basic data structure that is required for creating an LOV?
Record Group.

177. What is the Maximum allowed length of Record group Column?
Record group column names cannot exceed 30 characters.

178. Which parameter can be used to set read level consistency across multiple queries?
Read only

179. What are the different types of Record Groups?
Query Record Groups
NonQuery Record Groups
State
Record Groups

180. From which designation is it preferred to send the output to the printed?
Previewer


181. what are difference between post database commit and post-form commit?
Post-form commit fires once during the post and commit transactions process, after the database commit occurs. The post-form-commit trigger fires after inserts, updates and deletes have been posted to the database but before the transactions have been finalized in the issuing the command. The post-database-commit trigger fires after oracle forms issues the commit to finalized transactions.

182. What are the different display styles of list items?
Pop_listText_listCombo box

183. Which of the above methods is the faster method?
performing the calculation in the query is faster.

184. With which function of summary item is the compute at options required?
percentage of total functions.

185. What are parameters?

Parameters provide a simple mechanism for defining and setting the
valuesof inputs that are required by a form at startup. Form parameters are variables of type char,number,date that you define at design time.

186. What are the three types of user exits available ?
Oracle Precompiler exits, Oracle call interface, NonOracle user exits.

187. How many windows in a form can have console?
Only one window in a form can display the console, and you cannot change the console assignment at runtime

188.If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?
Only for 10 records.

189.What are the two repeating frame always associated with matrix object?
One down repeating frame below one across repeating frame.

190. What are the master-detail triggers?\
On-Check_delete_masterOn_clear_detailsOn_populate_details

191. What are the different objects that you cannot copy or reference in object groups?
Objects of different modules
Another object groups
Individual block dependent items
Program units.

192. What is an OLE?
Object Linking & Embedding provides you with the capability to integrate objects from many Ms-Windows applications into a single compound document creating integrated applications enables you to use the features form .

193. Is it possible to modify an external query in a report which contains it?
No.
194. Does a grouping done for objects in the layout editor affect the grouping done in the data model editor?
No.

195. Can a repeating frame be created without a data group as a base?
No
196. If a break order is set on a column would it affect columns which are under the column?
No

197. Is it possible to set a filter condition in a cross product group in matrix reports?
No
198. Do user parameters appear in the data modal editor in 2.5?
No
199. Can you pass data parameters to forms?
No
200. Is it possible to link two groups inside a cross products after the cross products group has been created?
no

Recent Tutorials