What is use of ROWS option in IMP command?
A flag to indicate whether rows should be imported. I f this is set to ‘N’ then only DDL for the database objects will be executed Read more »
Archive for May, 2008
What is the maximum number of characters the parameter?
The maximum number of characters the parameter can store is only valid for CHAR parameters, which can be up to 64k. Number parameters default to 23 bytes and DATE... Read more »
What are the built-ins used for modifying a group structure?
ADD_GROUP_COLUMN(function) ADD_GROUP_ROW(Procedure) DELETE_GROUP_ROW(Procedure) POPULATE_GROUP(function) POPULATE_GROUP_WITH_QUERY(function) SET_GROUP_CHAR_CELL(Procedure) SET_GROUP_DATE_CELL(Procedure) SET_GROUP_NUMBER_CELL(Procedure) Read more »
What are the built-ins used for creating and deleting?
CREATE_GROUP(function) CREATE_GROUP_FROM_QUERY(function) DELETE_GROUP(Procedure) Read more »
What is a Static Record Group?
A Static record group is not associated with a query,rather, you define its structure and row values at design time, and they remain fixed at runtime. Read more »
What is the maximum allowed length of a Record Group ?
Record group column names cannot exceed 30 characters. Read more »
How many number of columns a record group can have?
A record group can have an ultimate number of columns of type CHAR,LONG,NUMBER, and DATE provided that the total number of columns does not exceed 64k. Read more »
What are the built-ins that are used to attach an LOV?
Set_item_property Get_item_property (by setting the LOV_NAMEproperty) Read more »
What is an LOV?
An LOV is a scrollable popup window that provides the operator with either a single or multi-column selection list. Read more »
What are the built-ins to display the user-named editor?
A User-named editor can be displayed programatically with built in procedure SHOW_EDITOR,EDIT_TEXTITEM independent of any particular text item. Read more »
What are the minimum number of groups required for a matrix report?
The minimum of groups required for a matrix report . Read more »
What is Flex?
Flex is the property of moving the related fields together by setting the flex property . Read more »
What is the lock option in reports layout?
By using the lock option we cannot move the fields in the layout editor outside the frame. This is useful for maintaining the fields . Read more »
Can u run the report with out a parameter form?
Yes it is possible to run the report without parameter form by setting the PARAM value to Null Read more »
Can u have more than one layout in report?
It is possible to have more than one layout in a report by using the additional layout option in the layout editor. Read more »