Function  key  triggers  are  associated with individual SQL*FORMS function keysYou  can  attach  Key  function  triggers  to 10 keys or key sequences that normally  do  not perform any SQL * FORMS operations. These keys referred as key F0 through key F9.

priyank74

 Profile Answers by priyank74 Questions by priyank74

• Aug 30th, 2006

Function Key Triggers - are associated with individual Runform function keys. A function key trigger fires only when user presses the associated function key. The action defined in Function Key Trigge...

Answer Question  Select Best Answer

 POST-FIELD,ON-VALIDATE-FIELD,POST-CHANGE and KEY-NEXTFLD.KEY-NEXTFLD,POST-CHANGE, ON-VALIDATE-FIELD, POST-FIELD.

Nitin Gupta

• Sep 13th, 2006

ON-VALIDATE-FIELD -> KEY-NEXTFLD -> POST-FIELD -> POST-CHANGE

Answer Question  Select Best Answer

 These triggers are executes when inserting, deleting and updating operations are   performed  and  can  be  used  to  change  the  default  function  of insert, delete or update respectively. For  Eg,  instead  of  inserting  a  row  in a table an existing row can be updated in the same table.

raji

• Mar 31st, 2006

Hi Triggers are like stored pocedure consisting of batch of sql statements. ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS attached to the respective tables get fired when the tables gets manipulated by the query containing DML statements and checks for business logic inside the trigger object.

Answer Question  Select Best Answer

 No.

kISHORE

• Aug 17th, 2005

Yes  By creating a Visual Attribute  And Assign the Visual Attribute in SET_ITEM_PROPERTY

Answer Question  Select Best Answer

      Boilerplate Images     Image_items

Ravi

• Apr 3rd, 2006

For storing images in oracle we can use either CLOB or BLOB defined objectes, once the table is created with CLOB or BLOB data type, we can store images or documents or any junk into it. ThanksHRavi

Answer Question  Select Best Answer

akgorantla

 Profile Answers by akgorantla Questions by akgorantla

• Mar 24th, 2006

oracle Forms:-Oracle Forms are normal forms which are developed with Oracle forms tool in client side. oracle Apps Forms:-Apps forms are used in serverside oracle applications.if u want...

Answer Question  Select Best Answer

Siddhartha Doshi

• May 30th, 2006

Hi,These are libraries attched with the Template.fmb to support the menu, Toolbar, and other required standard behaviors.RegardsSiddhartha

Answer Question  Select Best Answer

kaye

• Aug 22nd, 2006

You have to use oracle SCM that goes with the designer.

Answer Question  Select Best Answer

nagendra

• Sep 29th, 2006

Take the isolated relation ship

Answer Question  Select Best Answer

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

 Profile Answers by dornalpr Questions by 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...

Answer Question  Select Best Answer

 INP (Source File)   FRM (Executable File)

parash_3380

 Profile Answers by parash_3380 Questions by parash_3380

• May 4th, 2006

Hiit create two files with extension FMB - Contains source codeFMX - It is executable file.

Amit Chintawar

• Mar 29th, 2006

FMB- You can open this fileFMX- This is in Executable mode, you cannot open this file

Answer Question  Select Best Answer

 No.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 6th, 2006

no you can not make two blocks with same name,not only block for same type of object you can not have same name.

Answer Question  Select Best Answer

 using On-Message or On-Error triggers.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 6th, 2006

other then on-error trigger , you can use  exception also in that blockwith the help of a small procedure and alert you can populate the message and with raise_form_trigger_failure transaction can be controlled.

Answer Question  Select Best Answer

 It  fires  when a value in a field has been changed and the field status is changed  or  new  and  the   key has been pressed. If the field status  is valid then any further change to the value in the field will not fire the on-validate-field trigger.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 6th, 2006

On-validate field tigger will fire when ever cursor moves from that field to next field, so first key-next will fire then validate.

Answer Question  Select Best Answer

 When you changes the Existing  value to null, the On-validate field trigger will  fire  post change trigger will not fire. At the time of execute-query post-change trigger will fire, on-validate field trigger will not fire.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 6th, 2006

On-validate field will fire after post-change trigger.  if value in field satisfy the validation then also post-change will fire when cursor leaves that field but after key-next

Answer Question  Select Best Answer

 When Execute-query or count-query Package procedures are invoked.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 6th, 2006

Pre-query trigger fires before any execution of a query.  this trigger fires only once per query. where as post query fires for each row.

Answer Question  Select Best Answer

 No.

raheemrao

 Profile Answers by raheemrao Questions by raheemrao

• Jun 1st, 2008

No, we cann't use go_block in pre_field trigger

Answer Question  Select Best Answer

 Erase removes an indicated global variable.

anitha palla

 Profile Answers by anitha palla Questions by anitha palla

• Aug 13th, 2010

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

Answer Question  Select Best Answer

 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

 Profile Answers by younaskhan40 Questions by 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

Answer Question  Select Best Answer

 ORACLE Precompliers user exitsOCI (ORACLE Call Interface)Non-ORACEL user exits. Page :

sumanpani

 Profile Answers by sumanpani Questions by sumanpani

• Sep 16th, 2008

You can write the following types of user exits: ORACLE Precompiler user exits OCI (ORACLE Call Interface) user exits Non-ORACLE user exits User exits can perform the following tasks: ...

Answer Question  Select Best Answer