kamaraj

• Mar 24th, 2019

In Oracle reports only 2 parameters
1. Bind parameter replaces single value in SQL, it is prefixed with :symbol
2. Lexical parameter replaces a statement in SQL, it is prefixed with &symbol

amruta shinde

• Aug 5th, 2014

Bind variables are used for replacing the single parameter in the select statement, where as Lexical Parameter is used to replace the where, order by conditions at run time

Answer Question  Select Best Answer

KAMARAJ

• Mar 24th, 2019

We cant handle the record one by one because it returns a result set

Pradeep

• Sep 23rd, 2014

If the number of records returned by cursor is more, it results in a performance issue. It is advised to use collections in this case.

Answer Question  Select Best Answer

Can :SYSTEM.CURRENT_BLOCK value be changed. If yes how? If no Why?With Example

kamaraj

• Mar 24th, 2019

We cant change built in procedure values, its pre defined

zahir

• Sep 11th, 2013

No we cannot change system variable.

Answer Question  Select Best Answer

kamaraj

• Mar 24th, 2019

Stacked canvas is load above content canvas, which is used for popup windows. We can show additional details for example if you want to show the customer details while click details button.

vishnu

• Jun 1st, 2015

How to create the stacked canvas.....please try to give me the brief idea about my requirement...In that you need to have two different canvases in one form. First canvas should show only semesters wi...

Answer Question  Select Best Answer

KAMARAJ

• Dec 16th, 2018

Bind refrences uses :varname
lexical refrences uses &varname in sql statement

kamaraj

• Dec 16th, 2018

Key next item trigger fires when we move next item(key board events such like tab or enter), it ill not fire when we click mouse to another item.

Answer Question  Select Best Answer

kamaraj

• Dec 16th, 2018

When-validate-item
key-next-item
post-change

kamaraj

• Dec 16th, 2018

1) Pre-logon
2) On Logon
3) Post logon
4) Pre-form
5)When-new-form
6) pre-block
7)when-new-block-instance
8)when-new-item-instance
9)when_validate_item
10)Key_next_item
11)post_text_iem
12)Post-block
13)post-form

Answer Question  Select Best Answer

kamaraj

• Dec 16th, 2018

Datablock -->property set query data source multiple table like(emp,dept) & where clause property join 2 tables like(emp.deptid=dept.id)

Sandeep

• Aug 23rd, 2016

Database Block can be based on more than one table. Query data source name: table names. Where clause: join query. The advantage of joining tables in your block is that the result set is faster than t...

Answer Question  Select Best Answer

What is the advantage of using Program units procedure over database procedure? What scenarios do we use program units procedure over database procedures?

kamaraj

• Dec 16th, 2018

Forms program units are local to form builder if you want to use without database you can use form program units else use database procedure

Sandeep

• Aug 23rd, 2016

Program unit procedures can be used when forms items (fields, data blocks) needs to be accessed. Otherwise it is better to use database procedures.

Answer Question  Select Best Answer

I am using Oracle forms. I want to know how to determine which tab the user is on in run time. For Example : I created 4 tabs in my canvas A,B,C,D. During run time, how do I get to know that which TAB is accessed by the user currently?

kamaraj

• Nov 2nd, 2017

Using get_item_propery you will get tab name
and display it

Answer Question  Select Best Answer

Hancock

• Jun 15th, 2017

You can change the page size dynamically at main section page
go to object navigator and click paper layout and then 3 objectives can be populated you have to click the main section two time then property inspector layout can be populated there you can change the width

Muhammad Farooq

• Apr 27th, 2017

Please guide how to use this parameter PAGESIZE
as I am trying but not working as below
PAGESIZE = 17*8 ;
this line wrote in before report trigger but showing error

Answer Question  Select Best Answer

Hancock

• Jun 15th, 2017

You can develop the queries by using report builder as
1.SQL
2.JDBC
3.OLAP
4.Text
5.XML
6.Ref

Naushad Hassan

• Feb 3rd, 2017

SQL, PLSQL(REF CURSOR), XML QUERY

Answer Question  Select Best Answer

Is It possible to use or develop grid in oracle d2k? if possible means how?

Sandeep

• Aug 23rd, 2016

Drag and drop one item on your canvas and set its block "no of records displayed" property to more than 1 then the block should look like a grid.

Answer Question  Select Best Answer

some tell me code to attach SecuGen thumb device and scan and handle attendance in form 6i.i'll be thank full....

Azhar Hussain

• Apr 27th, 2015

1.These devices use different DLLs to communicate with device , call these DLL in Oracle Forms.

2. Some time OCX controls are also available to communicate with devices

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

vinod_ce2005@hotmail.com  

 Profile Answers by vinod_ce2005@hotmail.com Questions by vinod_ce2005@hotmail.com

• Member Since Dec-2005 | Dec 29th, 2005

---

by using run_product we can call report from a form

kamaraj

• Feb 12th, 2015

Guys always give correct answer cz people think its correct

Using run_product(6i),run_report_object(10g)
set_report_object_property(repid,report_other,paramform=no) using this we can hide parameter form

radhika

• Apr 28th, 2012

We can call report from form directly from object navigator of form

Improve Answer

Illustrate a scenario where post change and pre-change trigger get fired?

raaj

• Jan 15th, 2015

I am unable to find pre- change trigger

ajaz_11i

 Profile Answers by ajaz_11i Questions by ajaz_11i

• Jun 24th, 2008

pre-change trigger fires when the value is changed or selected from the listitem andpost-change trigger fires when the value is changed after the value is selected from the list item.BY Mr. Aijaz Ahmad Kumar    D2k Expert

Answer Question  Select Best Answer

krishna

• Dec 20th, 2014

First WHEN-VALIDATE-ITEM and then next KEY-NEXT-ITEM

Ram Mohan

• Apr 8th, 2013

Always first "key_next_item" firs first and then "when_validate_item" fire,this is applicable for all levels .i.e form level,block level and item level

Answer Question  Select Best Answer

Can we add scroll bar at on all tab pages in a single canvas? If yes then how:

Udara

• Oct 18th, 2012

If still couldnt see the scroll bar, just look at the x and y coordination of the scroll bar. Change the values of hose two according to the size of the window. You will see the scroll bar on the canvas.

Udara

• Oct 17th, 2012

You can add whatever scroll bar to your form. Normally we add scroll bars to the data block. Therefore no matter whether the canvas is content or stack or tab one. Simply you can add a scroll bar to y...

Answer Question  Select Best Answer

Give an example for open_form with parameter passing from one form to another form?

siva krishna chowdary n

• Dec 21st, 2011

Call_form(file namw with path,no_hide,do_replace,no_query_only);

dinesh 9994988813

• Sep 24th, 2011

Code
span style="color: #ff0000;">'WINDOW1''this u r file save path''WINDOW1');

Answer Question  Select Best Answer

If you write NULL in on-error trigger defined in Form level of Forms 10g, then what will happen to the error message during runtime? Will the error message get displayed or not?

praduman jha

• Dec 10th, 2011

Dear All, Basically when we write null on on error then at that time, no error will display. At the backend when we want to search the on which packages are firing then write down ON_ERROR...

Nithin

• Jul 24th, 2011

Nothing Happens... the on-error trigger wont be handled in case a NULL is written in the trigger

Answer Question  Select Best Answer

abhishek

• Nov 30th, 2011

We can install two instance of oracle on a stand alone machine in two different directories and distinguish them by there different home names as orcl1,orcl2 we can work with both instances........

muraligrandhi

 Profile Answers by muraligrandhi Questions by muraligrandhi

• Dec 2nd, 2010

Yes, we can maintain two oracle databses in a single machine.For this we need to install two Operating systems in your machine, one is Windows and another one is Unix.After you that you should install the databases in the two Operating systems.

Answer Question  Select Best Answer