Oracle Forms Execute_Query Example To Fetch The Records From Database

Execute_Query command is used to fetch all the records for current database data block in Oracle Forms, actually its executes query in current data block.

Syntax

EXECUTE_QUERY;

Clears the current block, opens a query, and fetches a number of selected records.

EXECUTE_QUERY (keyword_one VARCHAR2);

EXECUTE_QUERY(ALL_RECORDS) performs the same actions as EXECUTE_QUERY but Oracle Forms fetches all of the selected records.

EXECUTE_QUERY(keyword_two VARCHAR2);

EXECUTE_QUERY(ALL_RECORDS, FOR_UPDATE) performs the same actions as EXECUTE_QUERY but it lock all of the selected records immediately and fetches all of the selected records.

EXECUTE_QUERY(keyword_one VARCHAR2, keyword_two VARCHAR2);

EXECUTE_QUERY(keyword_one VARCHAR2, keyword_two VARCHAR2, locking VARCHAR2);

Can be set to NO_WAIT anytime that you use the FOR_UPDATE parameter. When you use NO_WAIT, Oracle Forms displays a dialog to notify the operator if a record cannot be reserved for update immediately. Without the NO_WAIT parameter, Oracle Forms keeps trying to obtain a lock without letting the operator cancel the process.

Example

BEGIN
Go_Block('yourblock');
Execute_Query;
END;

Earlier I have given many example to perform query in Oracle Forms and below are the links that you can check for more details.