-
How does the command POST differs from COMMIT ?
Post writes data in the form to the database but does not perform database commitCommit permanently writes data in the form to the database.
younaskhan40
- Apr 20th, 2010
POST?will temporary?save?data in the relevant table.If you do not use commit after post then the temporary saved data will be lost.COMMIT permanently Save Data in the table
-
A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?
PRE-QUERY fires once. POST-QUERY fires 10 times.
younaskhan40
- Apr 20th, 2010
PRE-QUERY fire once when block goes in execute-query Mode.andPOST-QUERY fire=TOTAL NUMBER OF RECORDS RETRIEVED.in the above case POST-QUERY fires 10 times.
AShutosh Trivedi
- Jun 10th, 2006
Pre_Query fires onceAnd Post_Query fires for each record means in this condition it fires 10 times.
-
What is the difference between Property Pallete and Visual Attributes ?Also explain what is Object Group in Oracle Forms ?
santhisistla
- Jul 29th, 2010
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...
kyuvarajbe
- Jun 11th, 2010
Visual Attribute is the property in Property Pallete of object which deals with only text font,colour.
-
What ERASE package procedure does ?
Erase removes an indicated global variable.
anitha palla
- Aug 13th, 2010
Erase removes an indicated global variable and releases the memory associated with it.
-
Valid settings for the Initial Value property
In an Order Entry form, the Order_Items block has a text item called Shipping_Date, which is of the Date data type The Lowest Allowed Value and the Highest Allowed Value properties are not defined for this item.Assuming that all of the following are defined, which three are valid settings for the Initial Value property of the Shipping_Date item? (Choose three)A. $$DBDATE$$B. :Orders.Order_date+3C....
dornalpr
- Jun 2nd, 2011
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...
-
What is a Trigger ?
A piece of logic that is executed at or triggered by a SQL *forms event.
Bashartullakhan
- Aug 17th, 2011
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.
manishagoyal23
- Sep 4th, 2009
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...
-
What is folder form?
Definitions, Usage and its Information in Oracle forms 9i
Lokesh M
- Dec 8th, 2011
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.
-
WebUtils
Actual I am uploading the excel sheet data in the customer system that must generate into server system and store that excel sheet data into the particular database table...Plz help me.....we r trying from so many days ... my task has been stop there
-
Message error
How can I get off a error message oracle form A0001 ask me to save the record when I change a record to other ?
-
Lists in Oracle forms
I want to make two lists in an oracle form. Each list will be holding three elements. These elements are same for two lists. If one element is selected in one list that will not come in the other list. That means the other list will show only two elements. How can I do that dynamically ?
-
Can you truncate a table in a procedure in Oracle Forms? The table name is passed into the procedure.
Shital Mistry
- Aug 12th, 2012
It is not directly supported in forms, but FORMS_DDL built in can be used to TRUNCATE the table.
rampratap409
- Dec 4th, 2006
yescreate procedure truncatetable(tname in varchar2) issqlstr varchar2(100);beginsqlstr := 'truncate table '||tname;execute immediate sqlstr;end;
-
How do you pass the parameters from one form to another form?
To pass one or more parameters to a called form, the calling form must perform the following steps in a trigger or user named routine execute the create_parameter_list built-in function to programmatically. Create a parameter list to execute the add parameter built-in procedure...
Shital Mistry
- Aug 11th, 2012
Calling form must first create parameters under the parameter node.
younaskhan40
- Apr 16th, 2010
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.
-
Background_color
In the Manual datablock , we will get records from database then I need to get each row in different color ......I am using the set_item_property('blockname.item',current_row_background_color,'red');plz help me.............
asifinet
- Feb 16th, 2013
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...
SANJIT
- Jan 20th, 2013
Code -
Can we use program unit in a display field to create a formula calculated item?
-
What are dynamic reports? How will you create them
asifinet
- Feb 16th, 2013
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 ...
-
How will you post two independent transactions in forms 6i
asifinet
- Feb 16th, 2013
Declare the PRAGMA AUTONOMUS_TRANSACTION; in Procedure,Package,Function/Anonymous Block etc.
-
-
How to get number in words in Oracle 10g Reports
How to get number in words we are using Oracle 10g software and in reports, i am trying to give as function code and return value as placeholder, but i am getting an error as foll.REP:1401 'cf_1formula': Fatal PL/SQL error occurred.Thanks in advanceKrishnan R
Ashish
- Mar 10th, 2014
"vb Function No_To_Word(Amount Number) Return Varchar2 Is Wordsamt Number(30, 12) := 0; Words Varchar2(500) := ; Str Varchar2(50) := ; Amt Number(30, 1...
asifinet
- Feb 16th, 2013
"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...
-
-
Can a Calculated item be stored in a database
Azhar Hussain
- Apr 28th, 2015
Yes it is possible indirectly,
On Pre-INSERT OR PRE-UPDATE assign to related database column
Oracle Forms Interview Questions
Ans