System.cordination_operation      System Date_threshold      System.effective_Date      System.event_window      System.suppress_working

imranbaig.geek

 Profile Answers by imranbaig.geek Questions by imranbaig.geek

• Mar 25th, 2010

System Variable in forms 10gSYSTEM.BLOCK_STATUS SYSTEM.COORDINATION_OPERATION SYSTEM.CURRENT_BLOCK SYSTEM.CURRENT_DATETIME SYSTEM.CURRENT_FORM SYSTEM.CURRENT_ITEM SYSTEM.CURRENT_VALUE SYSTEM.CURSOR_BL...

Answer Question  Select Best Answer

 A  library  is  a  collection of Pl/SQL program units, including user named procedures, functions & packages

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 14th, 2008

A library is a collection of subprograms, including user-named procedures, functions, and packages. Libraries provide a convenient means of storing client-side program units and sharing them among mul...

Answer Question  Select Best Answer

      Image_add     Image_and     Image_subtract     Image_xor     Image_zoom

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 15th, 2008

Image_addImage_andImage_subtractImage_xorIMAGE_ZOOM: Zooms the image in or out using the effect specified in zoom_type and the amount specified in zoom_factor.IMAGE_SCROLL: Scrolls the image item as c...

Answer Question  Select Best Answer

 Error_type      return character   Error_code      return number   Error_text       return char   Dbms_error_code   return no.   Dbms_error_text     return char

sandeep5580

 Profile Answers by sandeep5580 Questions by sandeep5580

• Mar 29th, 2008

Well i am not pretty sure about this. I think we can use sqlerrm to trap an error.Thanks.Sandeep

Answer Question  Select Best Answer

 Raise form_trigger_failure

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 15th, 2008

Raising the FORM_TRIGGER_FAILURE Exception: The FORM_TRIGGER_FAILURE exception is a predefined PL/SQL exception available only in Oracle Forms. Because it is predefined, you can raise this exception w...

Answer Question  Select Best Answer

K.MOHANRAJ

• Jan 24th, 2015

YES, USING WEBUTIL

Answer Question  Select Best Answer

gman

• Jul 25th, 2007

You can check and uncheck box by pressing spacebar as toggle key.

Answer Question  Select Best Answer

tejasvini

• Sep 26th, 2007

Oracle Container for J2EE is ideally suited to run forms applications

Answer Question  Select Best Answer

Definitions, Usage and its Information in Oracle forms 9i

Lokesh M

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

Answer Question  Select Best Answer

What do you mean by anchoring on object?

samareshp

 Profile Answers by samareshp Questions by samareshp

• Apr 20th, 2009

Anchors fasten an edge of one object to an edge of another object, ensuring that they maintain their relative positions. For example, you can anchor boilerplate text to the edge of a variable-sized re...

Answer Question  Select Best Answer

asifinet

 Profile Answers by asifinet Questions by asifinet

• Feb 16th, 2013

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

Answer Question  Select Best Answer

asifinet

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

Answer Question  Select Best Answer

asifinet

 Profile Answers by asifinet Questions by asifinet

• Feb 16th, 2013

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

Answer Question  Select Best Answer

table12345

 Profile Answers by table12345 Questions by table12345

• Aug 1st, 2008

Yes it can come from two blocks. If the cource block is database/from clause?query?block then just go to the POST-QUERY of that block where display item exist and write :block.display_item:=block1.field1||block.field2 int hat POST-QUERY.

Answer Question  Select Best Answer

renukuntanagaraj

 Profile Answers by renukuntanagaraj Questions by renukuntanagaraj

• Sep 10th, 2008

1. Open data model editor, increase the height of the group to make place for the formula column or summary column.2. Select the formula column tool button in the tool palette and place it after the l...

Answer Question  Select Best Answer

how can you generate the system _generate number in forms automaticallyhint: IN FORMS WE CREATING ONE DATA BLOCK BUT ONE CLOUMN (EMPLOYEE_ID) THIS COLUMN GENERATE THE ID NUMBER AUTOMATICALLY WITH OUT CREATING SEQUNENCE

usmanahmad

 Profile Answers by usmanahmad Questions by usmanahmad

• Aug 18th, 2008

1: EMPLOYEE_ID := DBMS_RANDOM.STRING('X',6); ---- its generates unique EMPLOYEE_ID six char long 2: Then check whether newly generated id is already in DB. Create a cursor which select and return ids ...

Answer Question  Select Best Answer

Why do we use data source as procedure in Oracle forms? What is the use of taking procedure as Data Source?

rvnambiar

 Profile Answers by rvnambiar Questions by rvnambiar

• Nov 30th, 2008

To increase the control and securityTo specify a Query at runtime, Eg: in case of manager logs in he can see more info wherein if its employee he will be able to see less dataIf you wanna specify any ...

Answer Question  Select Best Answer

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

keerthikannan v

• Jan 23rd, 2012

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: ...

Answer Question  Select Best Answer

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