Oracle Forms Interview Questions

use I/O package .

"sql Set Serveroutput On 1000000 Declare V_Input NUMBER := &TESTED; Function Numbertowords(P_Number In Out Number) Return Varchar2 Is V_Words Varchar2(32767) := ; V_Te...

Question is not clear to me. Specify some details what exactly you want to do?

Declare the PRAGMA AUTONOMUS_TRANSACTION; in Procedure,Package,Function/Anonymous Block etc.

Dynamic Reports are the Reports which is based on the GLOBAL_TEMPORARY TABLE. can be used in BEFORE RUN REPORT Trigger to populate the Data into that table by calling function/procedure. After report ...

Yes we can, in WHEN-NEW-RECORD-INSTANCE Trigger.

You can use SET_BLOCK_PROPERTY(blk_name,record_no, CURRENT_RECORD_ATTRIBUTE,Visual_attribute_name); Must create two Visual Attributes one with yellow background color one with default name them VA_Y...

Code
SET_ITEM_PROPERTY(ACCOUNT_MASTER.ACCT_NO,CURRENT_ROW_BACKGROUND_COLOR,r100g50b0);
 
SET_ITEM_PROPERTY(ACCOUNT_MASTER.ACCT_NO,CURRENT_ROW_FOREGROUND_COLOR,r100g100b88);

It is c. Character data type.

It is of type Character as you always compare

if :system.last_record = 'TRUE' then
........
........
end if;

Calling form must first create parameters under the parameter node.

Create parameter list.
Add required parameters  with add_parameter(receiving_parameter_name, field type, sending_parameter_name)
Now pass this into call_form or open_form built_in procedure.

It is not directly supported in forms, but FORMS_DDL built in can be used to TRUNCATE the table.

yes

create procedure truncatetable(tname in varchar2) is

sqlstr varchar2(100);

begin

sqlstr := 'truncate table '||tname;

execute immediate  sqlstr;

end;

use record group to hold the values of list items selected in first list populate second list dynamically only the items that you need and not contained in record group.

If it an oracle error you are trying to trap than I would use ON-ERROR trigger on specific block, use built ins DBMS_ERROR_CODE, DBMS_ERROR_TEXT to trap the error.

I would write ON_MESSAGE trigger on block level, trap particular message with built ins MESSAGE_CODE, MESSAGE_TEXT and handle the error...

Following Step need to setup before executing the Conversion Script Step 1: Logon to the Database server and connect to the database. Step 2: Run the below query and it should return five records: ...

Oracle Applications - Folder Functionality are made use of in custom forms. Folder Functionality enables user to perform host of actions on fields such as ordering, renaming, resizing, moving, including, excluding etc., in a multi-row block.

First: check through Get_List_Element built_ins method that the both list has been selected with the value or not? if none is selected then all values should be populated . Second: Declare a varray a...

Create this procedure first:PROCEDURE Pop_List IS /* ** Built-in: CREATE_GROUP_FROM_QUERY **Example: Create a record group from a query, and populate it. */ list_id ITEM; list_name VARCHAR2(40) := &...

Triggers are a special PL/SQL construct similar to procedures. However, a procedure is executed explicitly from another block via a procedure call, while a trigger is executed implicitly whenever the triggering event happens. The triggering event is either a INSERT, DELETE, or UPDATE command.

A forms trigger is a block of PL/SQL code that adds functionality to your application. Triggers are attached to objects in your application. When a trigger is fired, it executes the code it contai...

no

a single canvas have multiple windows :: NO

a single windows have multiple canvas :: yes

Valid values are: A, B & DIn forms, to give initial value as sysdate, we should user $$DBDATE$$ which gives the current time of server, which stores date of DD-MON-YYYY format. If you want to stor...

Erase removes an indicated global variable and releases the memory associated with it.

Property pallete is used to apply changes to only that object item, as visual attributes are used in more generic manner. Visual attributes are used  in the projects in which common specific...

Visual Attribute is the property in Property Pallete of object which deals with only text font,colour.

PRE-QUERY fire once when block goes in execute-query Mode.
and
POST-QUERY  fire=TOTAL NUMBER OF RECORDS RETRIEVED.
in the above case POST-QUERY fires 10 times.