madhav_menti

 Profile Answers by madhav_menti Questions by madhav_menti

• Apr 4th, 2008

In this senario?Better to ?use record group. Using record group we dump the table data at client system level and check the entered data. To achive this you write functions to find dup record under ...

osden

• Oct 7th, 2007

Create a trigger at form level When-database-trigger Post;  (this
command will temporary apply the changes to the database) Than you find by Sql
Query if it is duplicate Record.

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

dmdevaraj

 Profile Answers by dmdevaraj Questions by dmdevaraj

• Apr 29th, 2008

To writeDeclareT_filename Text_Io.File_Type;w_NewLine    varchar2(200); BeginT_filename := Text_Io.Fopen('c:test.txt', 'W');Text_Io.Put_Line(T_filename,'this is test...

kameshakundy

 Profile Answers by kameshakundy Questions by kameshakundy

• Jun 22nd, 2006

The CLIENT_IO is just a replacement for TEXT_IO since the client-server mechanism is becoming obselete

Answer Question  Select Best Answer

sameeridol21

 Profile Answers by sameeridol21 Questions by sameeridol21

• Jul 21st, 2010

The property used to define the relative position of one field with another is Anchor

osden

• Oct 7th, 2007

In properties -> Record -> Distance Between Records (Default value is 0).

Answer Question  Select Best Answer

osden

• Oct 7th, 2007

Download the Barcode 39 fontIn the Form label Report Encode the value *+ value+ *???????? for eg '*'||:itemcode||'*'???????? (*00001*)And assign this font to the repective field.You can print barcode labels

srilaxmi

• Apr 22nd, 2006

D2K ARE sql forms and sql reports.nothing but front end access to desing the forms with the help of built ins.WHEN U OPEN A FORM IT CONTAINS AN OBJECT NAVIGATOR SHOWING ALL THE INTRINSIC SUPPORTERS OF...

Answer Question  Select Best Answer

sreenivasulu bheemisetty

• Sep 7th, 2006

Hi.. U can use the builting GET_FILE_NAME .  Here are the parameters if u want u can pass these parameters.FUNCTION GET_FILE_NAME  (directory_name   VARCHAR2,   ...

uvarajd

 Profile Answers by uvarajd Questions by uvarajd

• Aug 16th, 2006

I don't see the "Common Dialog" class at all from the OLE importer. Could you please clarify how to do the same. I really need the answer very soon. Thanks in advance !!!

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

imranbaig.geek

 Profile Answers by imranbaig.geek Questions by imranbaig.geek

• Mar 23rd, 2010

Oracle Forms for Microsoft Windows supports Dynamic Data Exchange(DDE), a mechanism by which applications can communicate and exchange data. DDE client support is a procedural extension to Oracle Form...

ajay2222@gmail.com

 Profile Answers by ajay2222@gmail.com Questions by ajay2222@gmail.com

• Dec 21st, 2006

Sir can you tell me any sites name where i can getproject in D2Kajay singh

Answer Question  Select Best Answer

summa

• Feb 6th, 2007

Using Text_IO package the form data will store in Excel sheet

anilpj2

 Profile Answers by anilpj2 Questions by anilpj2

• Nov 7th, 2006

by using "TEXT_IO" packagefor example:decalre

Answer Question  Select Best Answer

samareshp

 Profile Answers by samareshp Questions by samareshp

• Apr 1st, 2009

pre query  will fire ONCE post query will fire as many records are there.

shamkohli

 Profile Answers by shamkohli Questions by shamkohli

• Jun 17th, 2008

Both Pre Query and Post Query would fire as many times as the number of records in the detail block

Answer Question  Select Best Answer

pchandna

 Profile Answers by pchandna Questions by pchandna

• Jul 22nd, 2009

Use COPY & NAME_IN BUILT-IN at with the help of System.cursor.record when-New-record-Instance trigger to copy and paset value from previous to next record

najim_t

• Sep 23rd, 2007

Hi   Press F3 from on copy one filed. press F4 . it will create same next recordN.TanwirsevenseasgroupDubai

Answer Question  Select Best Answer

samareshp

 Profile Answers by samareshp Questions by samareshp

• Apr 9th, 2009

Decode(col1,value1,x, value2,y, value3,z, value4,a, Q)it serves as if.else condition ....if col1=value1 then x,elsif col1=value2 then y,elsif col1=value3 then z,elsif col1=value4 then y else Q......

Raghu2008

 Profile Answers by Raghu2008 Questions by Raghu2008

• Aug 6th, 2008

The decode function is used to read the value from the given column and check 'if' the given column value and given if value is same then return the value other wise return the else value. Like this i...

Answer Question  Select Best 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

I am making an oracle 10g report and in Query Builder I tried to use lexical reference after the from clauselike SELECT ORDID, TOTALFROM &ATABLE;But it was showing me an error "invalid table name"Can't i use a lexical reference to make me enter the table name at run time?please help.

Rkhatri

 Profile Answers by Rkhatri Questions by Rkhatri

• Feb 25th, 2009

It is working fine with Oracle 10g and even with 11gSQL>select &a, &b from &tablename;It will ask respective values and it work fine

jitendra_kumar

 Profile Answers by jitendra_kumar Questions by jitendra_kumar

• Oct 31st, 2008

Lexical references is used to runtime dynamic where conditions. If you create query through query builder colon(:) must be used and this is used in after parameter form.
Jitendra kumar(software Engineer).

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

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

rajnish2008

 Profile Answers by rajnish2008 Questions by rajnish2008

• Sep 9th, 2008

You can create a record group using your query in the form. Then you can pass record group as data_parameter to the report. This way query in the report will get replaced by the record group query passed from forms.

prasant0661

 Profile Answers by prasant0661 Questions by prasant0661

• May 30th, 2008

You can put the query result in temprary table then  use it in report

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