How image_items can be populate to field in forms 4.0?

1 Answer

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.

Related questions

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 : What are some reasons why we (humans) populate the coast more than the middle of the country?

Last Answer : Commerce. People make a living buying and selling things from each other, the coasts have the action.

Description : What do you feel about the growing number of cliques that seem to populate sites like this?

Last Answer : Cliques are for those to weak to stand by themselves. I have the fortitude to stand on my own.

Description : What's the simplest way to create a web form that will populate a SQL database?

Last Answer : Give Forms To Go a try.

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

Last Answer : Execute Trigger (trigger-name)

Description : What is a library in Forms 4.0?

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

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 : 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 : Can a field be used in a report without it appearing in any data group?

Last Answer : Yes

Description : There is a % sign in one field of a column. What will be the query to find it?

Last Answer : '' Should be used before '%'.

Description : .Can you attach an alert to a field?

Last Answer : No

Description : Can you attach an lov to a field at design time?

Last Answer : Yes

Description : Can you attach an lov to a field at run-time? if yes, give the build-in name.?

Last Answer : Yes. Set_item_proprety

Description : List the system variables related in Block and Field?

Last Answer : 1. System.block_status 2. System.current_block 3. System.current_field 4. System.current_value 5. System.cursor_block 6. System.cursor_field 7. System.field_status.

Description : Can we use GO-BLOCK package in a pre-field trigger ?

Last Answer : No

Description : Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?

Last Answer : No

Description : What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?

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

Description : What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?

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

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.