I want to retrieve data from table where apply date field from table which likedate = sysdate,so i not got a data , what i doe.g.select date from abc where date = sysdate;this is right or wrong ,plz give ans

prasant0661

 Profile Answers by prasant0661 Questions by prasant0661

• May 16th, 2008

Select app_date from application where app_date=sysdate;The above query is right but may not fetch record.sysdate defult format is = 'dd/mm/yyyy hh:mi:ss'app_date might format may be = 'dd/mm/yyyy'so please writeselect app_date from applicationwhere trunc(app_date)=trunc(sysdate)

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

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

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

bc_sumanamara

 Profile Answers by bc_sumanamara Questions by bc_sumanamara

• Jan 12th, 2009

ON-DELETE IS USER TO TRAP DEFAULT DML USED AT FORM LEVEL AND BLOCK LEVEL EXAMPLE : BEGIN   UPDATE emp      SET termination_date = SYSDATE    WHERE emp...

ysumanth

• Oct 27th, 2005

  Override on- triggers on insert /ondelete / on update

Answer Question  Select Best Answer

bc_sumanamara

 Profile Answers by bc_sumanamara Questions by bc_sumanamara

• Jan 13th, 2009

We can use condition parameter to set parameter.

smithamd

 Profile Answers by smithamd Questions by smithamd

• Jan 10th, 2006

By using add_parameter builtin you can add values to the report parameter at runtime

Answer Question  Select Best Answer

MK

• Dec 27th, 2006

Do not establish the Master-Detail relationship in the data block wizard. Then, populate the detail block in the Query only mode or you can also write the navigational trigger: When-New-Block-Instance.

R A J

 Profile Answers by R A J Questions by R A J

• Feb 1st, 2006

HiU have to set the following property in detail block's relation objectDeferred=Yes,  Automatic Query=Yes When a coordination-causing event occurs, Form Builder defers fetching the associated detail records until the operator navigates to the detail block.

Answer Question  Select Best Answer

Chandra K. Ravi

• Aug 13th, 2007

A Summary Column Return a Single Value on multiple records.  Place Holder Column Holds a Data as a Variable. You can pass a data from one group to other group by the help of Place holder column.

Mohammed Saleem

• Mar 7th, 2006

SUmmary Column is where we can have the sum of particular columneg: sum of total salary place holder column: is the one where you can substitute the code written at runtime to a field which is empty at the design time.

Answer Question  Select Best Answer

adarsh_sp

 Profile Answers by adarsh_sp Questions by adarsh_sp

• Oct 3rd, 2006

In the KEY-NEXT-ITEM trigger write the plsql codeselect enum,rowid into :ENUM,:ROWID from EMPLOYEE  e where rowid<(Select min(rowid) from employee where rowid<e.rowid).

adarsh_sp

 Profile Answers by adarsh_sp Questions by adarsh_sp

• Oct 3rd, 2006

In the key next item trigger write the plsql codeselect enum,rowid into :ENUM,:ROWID from EMPLOYEE where rowid<(Select min(rowid) from employee where rowid<e.rowid).

Answer Question  Select Best Answer

manishks86

 Profile Answers by manishks86 Questions by manishks86

• Jul 25th, 2011

In 1992, Oracle version 7 was released with support for integrity constraints, stored procedures and triggers. In 1997, Oracle version 8 was released with support for object-oriented development a...

anilreddy02

 Profile Answers by anilreddy02 Questions by anilreddy02

• Aug 17th, 2010

In 6i -> Report6i program units, layout modules, anchors, conflex and flex modes, frames and repeated frames.

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

sameeridol21

 Profile Answers by sameeridol21 Questions by sameeridol21

• Jul 21st, 2010

A trigger is PL/SQL function which will fire whenever a corresponding event occures. The sequence of the triggers as follows1> When-validate-item2> Post-text-item 3>Key-Next-Item4>when-new-item-instance.

Raghu2008

 Profile Answers by Raghu2008 Questions by Raghu2008

• Aug 6th, 2008

A trigger is PL/SQL block which will fire whenever a corresponding event occures. The sequence of the triggers are Key-Next-Item, When_validate_item, Post_item and when-new-item-instance.Thanks,Rahgu.

Answer Question  Select Best Answer

bc_sumanamara

 Profile Answers by bc_sumanamara Questions by bc_sumanamara

• Jan 12th, 2009

Fires when Form Builder would normally execute the open cursor, parse, and execute phases of a query, to identify the records in the database that match the current query criteria. FORM AND BLOCK LEVE...

liz

• Sep 13th, 2006

1)On select fires first.On select fFires when Forms Developer would normally execute the open cursor, parse, and execute phases of a query, to identify 2)On fetch fires nextWhen a query is first opene...

Answer Question  Select Best Answer

Confine Mode:ON: Child objects cannot be moved outside their enclosing parent object.OFF:Child objects can be moved outside their enclosing parent object.Flex Mode:ON:Parent borders "stretch" when child objects are moved against them.OFF:Parent borders remain fixed when child objects are moved against them.

geetha24

 Profile Answers by geetha24 Questions by geetha24

• Mar 15th, 2007

Also By default Confine Mode - On                 Flex Mode - Off- Geetha

gangadharam.p

• Jan 6th, 2007

Confine Mode:ON: Child objects cannot be moved outside their enclosing parent object.OFF:Child objects can be moved outside their enclosing parent object.Flex Mode:ON:Parent borders "stretch" when chi...

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

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

sameeridol21

 Profile Answers by sameeridol21 Questions by sameeridol21

• Jul 21st, 2010

The return type for Oracle Apps report trigger is Boolean ie TRUE Or FALSE

Mital Mehta

• Sep 27th, 2007

That Will be Boolean like True or false

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

Vishal Rana

• Feb 3rd, 2006

 FILENAME := GET_FILE_NAME(File_Filter=> 'PDF Files (*.PDF)|*.PDF|'); SHOW_FILE:= '"'||FILENAME||'"'; HOST(SHOW_FILE);  Contact me at 09880603773

Shriram

• Dec 8th, 2005

You have to user DDE.App_begin.DDE.APP_end,DDE.Initiate,dde.Close.  If u have to write then u have to use dde.poke

Answer Question  Select Best Answer

zahid92005

 Profile Answers by zahid92005 Questions by zahid92005

• Feb 23rd, 2010

This trigger fires forces the cursor to be taken to the next available item or data block. 

Venkata Ramana

• Sep 14th, 2006

Key-Next-item trigger will fire whenver the user try to move the control(i.e., cursor) from one item to another item in the form by pressing return key or tab key.

Answer Question  Select Best Answer