VIKASH KUMAR

• Mar 12th, 2013

Use I/O package .

Answer Question  Select Best Answer

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 ?

Shital Mistry

• Aug 11th, 2012

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.

Answer Question  Select Best Answer

What are static and dynamic reports in oracle and where do we use them?

kamaraj

• Jul 13th, 2015

Static reports query is known in design time
Dynamic reports query is known during run time only

Answer Question  Select Best Answer

 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

 SQL  *forms  is  4GL  tool  for  developing  and  executing;  Oracle  based interactive application.

 False.

 On-validate-field  trigger  fires,  when the field Validation status New or changed.Post-field-trigger  whenever  the  control  leaving form the field, it will fire.

 Post-field trigger fires whenever the control leaving from the filed.Post-change trigger fires at the time of execute-query procedure invoked or filed validation status changed.

 a. ON-INSERT b. POST-INSERT c. PRE-INSERT PRE-INSERT,ON-INSERT & POST-INSERT.

 No.

 Execute Trigger (trigger-name)