What is a library in Forms 4.0?

1 Answer

Answer :

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

Related questions

Description : What is a library?

Last Answer : A library is a collection of subprograms including user named procedures, functions and packages.

Description : Can you store objects in library?

Last Answer : Referencing allows you to create objects that inherit their functionality and appearance from other objects. Referencing an object is similar to copying an object, except that the resulting reference ... the source object when you open or regenerate the module that contains the reference object.

Description : Explain the following file extension related to library?

Last Answer : .pll,.lib,.pld The library pll files is a portable design file comparable to an fmb form file The library lib file is a plat form specific, generated library file comparable to a fmx form file The pld file is Txt format file and can be used for source controlling your library files Parameter

Description : Is it possible to attach same library to more than one form?

Last Answer : Yes

Description : Where is a procedure return in an external pl/sql library executed at the client or at the server?

Last Answer : At the client.

Description : What is the advantage of the library?

Last Answer : Libraries provide a convenient means of storing client-side program units and sharing them among multiple applications. Once you create a library, you can attach it to any other form, ... library can reference program units in the attached library. Library support dynamic loading-that is library

Description : What are the default extensions of the files created by library module?

Last Answer : The default file extensions indicate the library module type and storage format .pll - pl/sql library module binary

Description : How can you execute the user defined triggers in forms 3.0 ?

Last Answer : Execute Trigger (trigger-name)

Description : How image_items can be populate to field in forms 4.0?

Last Answer : A fetch from a long raw database column PL/Sql assignment to executing the read_image_file built_in procedure to get an image from the file system.

Description : What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

Last Answer : Add_parameter Create_Parameter_list Delete_parameter Destroy_parameter_list Get_parameter_attr Get_parameter_list set_parameter_attr

Description : What are the design facilities available in forms 4.0?

Last Answer : Default Block facility. Layout Editor. Menu Editor. Object Lists. Property Sheets. PL/SQL Editor. Tables Columns Browser. Built-ins Browser.

Description : List the editors availables in forms 4.0?

Last Answer : Default editor User_defined editors system editors.

Description : Give the equivalent term in forms 4.0 for the following. Page, Page 0?

Last Answer : Page - Canvas-View Page 0 - Canvas-view null.

Description : What are the menu items that oracle forms 4.0 supports?

Last Answer : Plain, Check,Radio, Separator, Magic

Description : What is a predefined exception available in forms 4.0?

Last Answer : Raise form_trigger_failure

Description : List system variables available in forms 4.0, and not available in forms 3.0?

Last Answer : System.cordination_operation System Date_threshold System.effective_Date System.event_window System.suppress_working

Description : List the windows event triggers available in Forms 4.0?

Last Answer : When-window-activated, when-window-closed, when-window-deactivated, when-window-resized

Description : What is the significance of PAGE 0 in forms 3.0 ?

Last Answer : Hide the fields for internal calculation.

Description : How do you trap the error in forms 3.0 ?

Last Answer : using On-Message or On-Error triggers.

Description : What are the two ways to incorporate images into a oracle forms application?

Last Answer : Boilerplate Images Image_items

Description : How do you call other Oracle Products from Oracle Forms?

Last Answer : Run_product is a built-in, Used to invoke one of the supported oracle tools products and specifies the name of the document or module to be run. If the called product is unavailable at the time of the call, Oracle Forms returns a message to the operator.

Description : When a form is invoked with call_form, Does oracle forms issues a save point?

Last Answer : Yes

Description : For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

Last Answer : Yes

Description : Can u have VBX and OCX controls in forms ?

Last Answer : Yes.

Description : Can u have OLE objects in forms?

Last Answer : Yes.

Description : Can u set default font in forms?

Last Answer : Yes. Change windows registry(regedit). Set form45_font to the desired font.

Description : Can you issue DDL in forms?

Last Answer : yes, but you have to use FORMS_DDL. Referencing allows you to create objects that inherit their functionality and appearance from other objects. Referencing an object is similar to copying an ... values of bind variables can be concatenated into the string before passing the result to FORMS_DDL.

Description : Is forms 4.5 object oriented tool ? why?

Last Answer : yes , partially. 1) PROPERTY CLASS - inheritance property 2) OVERLOADING : procedures and functions.

Description : What are the built_in used to trapping errors in forms 4?

Last Answer : Error_type return character Error_code return number Error_text return char Dbms_error_code return no. Dbms_error_text return char

Description : What package procedure used for invoke sql *plus from sql *forms ?

Last Answer : Host (E.g. Host (sqlplus))

Description : How do you control the constraints in forms ?

Last Answer : Select the use constraint property is ON Block definition screen.BLOCK

Description : What is an SQL *FORMS ?

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

Description : What are the default extensions of the files created by forms modules?

Last Answer : .fmb - form module binary .fmx - form module executable

Description : What is the difference between object embedding & linking in Oracle forms?

Last Answer : In Oracle forms, Embedded objects become part of the form module, and linked objects are references from a form module to a linked source file.

Description : Can you pass data parameters to forms?

Last Answer : No

Description : An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?

Last Answer : True

Description : What are the Built-ins used for sending Parameters to forms?

Last Answer : You can pass parameter values to a form when an application executes the call_form, New_form, Open_form or Run_product.

Description : Are free tax forms 1040 available at a public library?

Last Answer : Not only are tax forms available at the public library, but tax help is available as well. Libraries often provide tax-assistance classes during tax season. Your local library's website should list when and where.

Description : Can I get business tax forms at the library?

Last Answer : You can get your business tax forms at your local library. For more information on this specific matter see :www.laserlibrarian.com/Tax-Forms-Library.asp

Description : What is the main diff. bet. Reports 2.0 & Reports 2.5?

Last Answer : Report 2.5 is object oriented.

Description : There is a string 120000 12 0 .125 , how you will find the position of the decimal place?

Last Answer : INSTR('120000 12 0 .125',1,'.') output 13

Description : Explain types of Block in forms4.0?

Last Answer : Base table Blocks. Control Blocks. 1. A base table block is one that is associated with a specific database table or view. 2. A control block is a block that is not associated with a database table. ITEMS

Description : Can we create two blocks with the same name in form 3.0 ?

Last Answer : No

Description : How free extents are managed in Ver 6.0 and Ver 7.0 ?

Last Answer : Free extents cannot be merged together in Ver 6.0. Free extents are periodically coalesces with the neighboring free extent in Ver 7.0

Description : What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?

Last Answer : LOVs can be attached to parameters in the reports 2.5 parameter form.

Description : If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?

Last Answer : While both reports 2.0 and 2.5 create the parameter, report 2.5 gives a message that a bind parameter has been created.

Description : What does "jumps off the screen" mean?

Last Answer : answer:AMD is a relatively small manufacturer but well established in the industry. In this context, AMD jumps off the screen at the guy doing the research into acquiring companies for ... chip manufacturing division, but AMD is the one that really stands out from an acquisition perspective.

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?

Description : Can one export a subset of a table? (for DBA

Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"