What are built-ins used for Processing rows?

1 Answer

Answer :

GET_GROUP_ROW_COUNT(function)
GET_GROUP_SELECTION_COUNT(function)
GET_GROUP_SELECTION(function)
RESET_GROUP_SELECTION(procedure)
SET_GROUP_SELECTION(procedure)
UNSET_GROUP_SELECTION(procedure)

Related questions

Description : What are the built-ins used for processing rows?

Last Answer : Get_group_row_count(function) Get_group_selection_count(function) Get_group_selection(function) Reset_group_selection(procedure) Set_group_selection(procedure) Unset_group_selection(procedure)

Description : What are the Built-ins to display the user-named editor?

Last Answer : A user named editor can be displayed programmatically with the built in procedure SHOW-EDITOR, EDIT_TETITEM independent of any particular text item.

Description : What are the built -ins used for Modifying a groups structure?

Last Answer : ADD-GROUP_COLUMN (function) ADD_GROUP_ROW (procedure) DELETE_GROUP_ROW(procedure)

Description : What are the built-ins used for Creating and deleting groups?

Last Answer : CREATE-GROUP (function) CREATE_GROUP_FROM_QUERY(function) DELETE_GROUP(procedure)

Description : What are the built-ins used for finding Object ID function?

Last Answer : FIND_GROUP(function) FIND_COLUMN(function)

Description : What are the built-ins used for finding object ID functions?

Last Answer : Find_group(function) Find_column(function)

Description : What are built-ins associated with timers?

Last Answer : find_timercreate_timerdelete_timer

Description : What are the built-ins used for Getting cell values?

Last Answer : GET_GROUP_CHAR_CELL (function) GET_GROUPCELL(function) GET_GROUP_NUMBET_CELL(function)

Description : What are the built-ins that are used for setting the LOV properties at runtime?

Last Answer : get_lov_property set_lov_property

Description : What are the built-ins that are used to Attach an LOV programmatically to an item?

Last Answer : set_item_property get_item_property (by setting the LOV_NAME property)

Description : What are the Built-ins used for sending Parameters to forms?

Last Answer : You can pass parameter values to a form when an application executes the call_form, New_form, Open_form or Run_product.

Description : What is the built-in routine used to count the no of rows in a group?

Last Answer : Get_group _row_count System Variables

Description : Deleting the Duplicate rows in the table

Last Answer : We can delete the duplicate rows in the table by using the Rowid

Description : If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ?

Last Answer : It won't, Because SYSDATE format contains time attached with it.

Description : How do you find the numbert of rows in a Table ?

Last Answer : A bad answer is count them (SELECT COUNT(*) FROM table_name) A good answer is :- 'By generating SQL to ANALYZE TABLE table_name COUNT STATISTICS by querying Oracle System Catalogues (e.g ... utility which Oracle released which makes it unnecessary to do ANALYZE TABLE for each Table individually.

Description : How will you delete duplicating rows from a base table?

Last Answer : delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name); or delete duplicate_values_field_name dv from table_name ta where rowid

Description : What is the use of ROWS option in IMP command ?

Last Answer : A flag to indicate whether rows should be imported. If this is set to 'N' then only DDL for database objects will be executed.

Description : What is the use of ROWS option in EXP command ?

Last Answer : Flag to indicate whether export should compress fragmented segments into single extents.

Description : Which parameter in Storage clause will reduce no. of rows per block?

Last Answer : PCTFREE parameter Row size also reduces no of rows per block.

Description : A table is having few rows, should you create indexes on this table

Last Answer : Small tables do not require indexes; if a query is taking too long, then the table might have grown from small to large. You can create an index on any column; however, if the ... , creating an index on the column does not increase performance and the index takes up resources unnecessarily.

Description : What are the PL/SQL Statements used in cursor processing ?

Last Answer : DECLARE CURSOR cursor name, OPEN cursor name, FETCH cursor name INTO or Record types, CLOSE cursor name.

Description : Disadvantage in File Processing System?

Last Answer : ∙ Data redundancy & inconsistency. ∙ Difficult in accessing data. ∙ Data isolation. ∙ Data integrity. ∙ Concurrent access is not possible. ∙ Security Problems.

Description : The PC productivity tool that manipulates data organized in rows and coloumn is called a a) spreadhsheet b) word processing document c) presentation mechanism d) database record manager e) None of these

Last Answer : a) spreadhsheet

Description : Semi-join strategies are techniques for query processing in distributed database system. Which of the following is a semi-join technique? (A) Only the joining attributes are sent from one site to ... the attributes are sent from one site to another and then only the required rows are returned.

Last Answer : (C) Only the joining attributes are sent from one site to another and then only the required rows are returned.

Description : What does invoke built-in do?

Last Answer : This procedure invokes a method. Syntax: PROCEDURE OLE2.INVOKE (object obj_type, method VARCHAR2, list list_type := 0); Parameters: object Is an OLE2 Automation Object. method Is a method (procedure) ... OLE2 object. list Is the name of an argument list assigned to the OLE2.CREATE_ARGLIST function.

Description : What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

Last Answer : Add_parameter Create_Parameter_list Delete_parameter Destroy_parameter_list Get_parameter_attr Get_parameter_list set_parameter_attr

Description : List the built-in routines for the controlling canvas views during run-time?

Last Answer : Find_canvas Get-Canvas_property Get_view_property Hide_View Replace_content_view Scroll_view Set_canvas_property Set_view_property Show_view Alert

Description : Give built-in routine related to a record groups?

Last Answer : Create_group (Function) Create_group_from_query(Function) Delete_group(Procedure) 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)

Description : What is the built-in function used for finding the alert?

Last Answer : Find_alert Editors

Description : List the built-in routine for controlling window during run-time?

Last Answer : Find_canvas Get-Canvas_property Get_view_property Hide_View Replace_content_view Scroll_view Set_canvas_property Set_view_property Show_view Alert

Description : List the built-in routine for controlling window during run-time?

Last Answer : Find_window, get_window_property, hide_window, move_window, resize_window, set_window_property, show_View

Description : What is the built-in used to get and set lov properties during run-time?

Last Answer : Get_lov_property Set_lov_property Record Group

Description : List some built-in routines used to manipulate images in image_item?

Last Answer : Image_add Image_and Image_subtract Image_xor Image_zoom

Description : What built-in is used for changing the properties of the window dynamically?

Last Answer : Set_window_property Canvas-View

Description : What built-in is used for showing the alert during run-time?

Last Answer : Show_alert.

Description : What are the built-in used for getting cell values?

Last Answer : Get_group_char_cell(function) Get_groupcell(function) Get_group_number_cell(function)

Description : What is the use of image_zoom built-in?

Last Answer : To manipulate images in image items.

Description : What is new_form built-in?

Last Answer : When one form invokes another form by executing new_form oracle form exits the first form and releases its memory before loading the new form calling new form completely replace the first with the second ... the first form, the operator will be prompted to save them before the new form is loaded.

Description : Can you built indexes online?

Last Answer : YES. You can create and rebuild indexes online. This enables you to update base tables at the same time you are building or rebuilding indexes on that table. You can perform DML operations while the ... online index build operations: CREATE INDEX emp_name ON emp (mgr, emp1, emp2, emp3) ONLINE;

Description : The various stages occuring in GPS system are described below: 1. Generation of an output to the user 2. Detection of the GPS signals 3. Processing the data in the built-in-computer 4. Decoding the GPS signal. The correct sequence of ... 4 (B) 2, 3, 4, 1 (C) 2, 4, 3, 1 (D) 3, 1, 2 , 4

Last Answer : Answer: Option C

Description : How do car trade-ins work?

Last Answer : Trade-ins are one way, advantage to the dealer. The trade value is not the retail resell value, trade-ins can be 60% to 75% of full retail. Remember Business 101, Buy low then sell high ... $2000 for the dealer to fix, repair, cover warranty expenses (returns for quality issues) and finally profit.

Description : What do you think of the new INS 'Secure Communities' program?

Last Answer : answer:The left wants open borders and those that cross them free to begin voting in the USA, but they can't say that. That's news to this leftie. I must have missed that memo. Anyway, I don't see ... know if it's a typo, but in the article you link to: What exactly is an excused drunk driver ?

Description : Coolest must have apps and plug-ins for a Mac?

Last Answer : YoBob what are your interests? What kind of work do you do? That would help narrow it down a bit.

Description : What can I read on the Web that will teach me the ins and outs of Android?

Last Answer : answer:Here's a list of articles that I found useful when making the switch to Android (from an iPhone) The best place to start would the be Beginner's Guide to Android on Androinica. There' ... can, it is probably the worst version of Android out there and really limits your phone's possibilities.

Description : How do I edit or delete Automator workflows that I have saved as Finder plug-ins?

Last Answer : Workflows that you have created are stored in your Home/Library/Workflows folder. Double-click them to open and edit in Automator.

Description : Scented candles, incense, plug-ins or wood fire?

Last Answer : I like scented candles, personally.

Description : What are page-ins and page-outs?

Last Answer : That is basically when your computer is using your hard drive for memory instead of RAM. RAM is lots faster so you want to keep both numbers low. Right now I am at about 2 million on both. But my ... Let us know how much Memory you have installed. If it is under 2 GB you could probably use more.

Description : Does locking your door really prevent break-ins?

Last Answer : this is just common sense answer ... but people probably first started locking doors for privacy reasons ... especially seeing as how people have more tendency to lock doors in cities than in country-side (may not ... (doesn't mean you won't, but less likely is better than nothing, right?) ... ^_^

Description : How can one prove domicile for INS if living with relatives?

Last Answer : How about cell phone bills? Do they have a driver's license or state ID card? Or paychecks? Or bank staements that come to your house?

Description : Anybody know of free iTunes visualizer plug-ins?

Last Answer : Doesn’t iTunes have its own built-in visualizer?