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

parash_3380

 Profile Answers by parash_3380 Questions by parash_3380

• Oct 19th, 2011

Hi Mr. Subrat, very good but when i set system parameters as destype=file and desformat=spreadsheet it is just showing on browser that "Successfully run" and nothing where as if i give destype=c...

subrat

• Oct 13th, 2011

Set system parameters

destype=file

and

desformat=spreadsheet
(100% tested) and secure

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

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

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

sameeridol21

 Profile Answers by sameeridol21 Questions by sameeridol21

• Jul 21st, 2010

Irrespective of number of records, between pages trigger will fire n-1 times.According to the Q -if it has 10 pages (1 record/page) then it will fire 9 times.If it has 5 pages (2 record/page) then it will fire 4 times.It will not fire from 10th to 1st record because it fires for 1st navigation.

Chandra K. Ravi

• Sep 6th, 2007

Mittal,? You are wrong.? Page between trigger ?Fire only 4 times. If there is? 5 pages in a report.C.K.Ravi3i-infotech

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

jagadeesh9

 Profile Answers by jagadeesh9 Questions by jagadeesh9

• Feb 19th, 2008

It is possible to convert report to another reportby using SRW.RUN_REPORT

ttparavindh

 Profile Answers by ttparavindh Questions by ttparavindh

• Dec 14th, 2007

When we creating drill down report, we would use this following parameterSRW.RUN_REPORT.

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

How many times pre query and post query fired when we fetch 10 record from a table ?

srinivas0808

 Profile Answers by srinivas0808 Questions by srinivas0808

• May 8th, 2009

Pre-Query fires one time and Post-Query fires 10 times.

samareshp

 Profile Answers by samareshp Questions by samareshp

• Apr 9th, 2009

Pre Query 1 Time - Before Query Post Query n Time ( n Times for n number of  records fetch by this query)

Answer Question  Select Best Answer

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

saleem

• Nov 21st, 2011

1) On-Check-Delete-Master Fires when Oracle Forms attempts to delete a record in a block that is Master block in a master-detail relation 2)On-Clear-Details Fires when Oracle Forms needs to clear rec...

shahnirav86

 Profile Answers by shahnirav86 Questions by shahnirav86

• Jul 2nd, 2008

1) Which trigger are created when master -detail rela?1) master delete property *  NON-ISOLATED (default) a) on check delete masterb) on clear detailsc) on populate details  *...

Answer Question  Select Best Answer

bc_sumanamara

 Profile Answers by bc_sumanamara Questions by bc_sumanamara

• Apr 3rd, 2009

Using :system.last_query

bc_sumanamara

 Profile Answers by bc_sumanamara Questions by bc_sumanamara

• Jan 12th, 2009

BY USING :SYSTEM.LAST_QUERY;EXAMPLE  WHEN-NEW-FORM-INSTANCEBEGIN  execute_query;MESSAGE(:SYSTEM,LAST_RECORD);END;RUN THE FORM...

Answer Question  Select Best Answer

Raghu2008

 Profile Answers by Raghu2008 Questions by Raghu2008

• Aug 6th, 2008

A global variable is used to store charecter?value upto 255 in length. It can be access throught the form module. The global variable always prefixed with ':Global.'ThanksRaghu.

jagadeesh9

 Profile Answers by jagadeesh9 Questions by jagadeesh9

• Feb 22nd, 2008

We r write pl/sql procedure r packageonly that particular session we use global temparary table once the session complete then global temparary table will be delected automatically.syn:Create global temparary table(-----)

Answer Question  Select Best Answer

samareshp

 Profile Answers by samareshp Questions by samareshp

• Apr 1st, 2009

Synonym,
Table,
View,
Trigger,
Materialized Views,
Indexes,
Sequence
LOB
Package
Package Body
Function
Procedure
Type

ttparavindh

 Profile Answers by ttparavindh Questions by ttparavindh

• Aug 7th, 2007

The following Objects are in OracleSequenceLOBPackagePackage BodyTriggerIndexTableSynonymFunctionViewProcedureType

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

mohan

• Jun 11th, 2007

It fires n-1 times

puneet arora

• Jan 2nd, 2007

Plz explain this point with example.

Answer Question  Select Best Answer

jagadeesh9

 Profile Answers by jagadeesh9 Questions by jagadeesh9

• Feb 22nd, 2008

Lexical P.M is used to pass string& is there it is Lexical P.M.we can use in FROM clausewe can't use in PL/SQL

devenar

 Profile Answers by devenar Questions by devenar

• Nov 19th, 2007

You can create a lexical parameter(references) by entering an ampersand (&) followed immediately by the column or parameter name.Lexical parameter are placeholders for text that you embed in a SEL...

Answer Question  Select Best Answer

kundancertain

 Profile Answers by kundancertain Questions by kundancertain

• Jan 25th, 2011

By using FND_STANDARD.SET_WHO in PRE_INSERT and PRE_UPDATE trigger, 5 who columns can be populated. But this work in Oracle Application form customization. 

nagendrap

 Profile Answers by nagendrap Questions by nagendrap

• Jan 10th, 2011

In pre-insert trigger by using 'fnd_standard.who' package?we can insert data into these two columns in Oracle forms.

Answer Question  Select Best Answer

J.Sreedharan

• Aug 21st, 2007

You can use host command in 9i/10g which will interact with the Application server's OS. If you want to access the client machine OS then you have to use WEBUTIL functionality

kameshakundy

 Profile Answers by kameshakundy Questions by kameshakundy

• May 31st, 2007

HOST command works fine with Oracle Developer 6i.Since Oracle Developer 9i and 10g are Web-enabled this became obsolete. In replacement of this, you need to install a utility called "Oracle WebUtil". ...

Answer Question  Select Best Answer