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

Raghu2008

 Profile Answers by Raghu2008 Questions by Raghu2008

• Sep 18th, 2008

You can create a .CSV file using Text_IO builtin.

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

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

I want to run a report daily, actually there is a whole data retrieving in one report so, i want the report daily at evening auto run and generate data and convert it into pdf, so how i it put the report in scheduled task?

Raghu2008

 Profile Answers by Raghu2008 Questions by Raghu2008

• Aug 6th, 2008

You can schedule the task using unix shell scripting and crontab file inorder to execute it on specified time.

Answer Question  Select Best Answer

vicky4gupshup

 Profile Answers by vicky4gupshup Questions by vicky4gupshup

• Jul 11th, 2008

use this                               &...

Answer Question  Select Best Answer

rakeskul

 Profile Answers by rakeskul Questions by rakeskul

• Jun 13th, 2008

There are two mathod 1 Click on insert and select the file link and put the path of logo2 Click on insert and use image and select logo for this no path is requiry

Answer Question  Select Best Answer

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

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

What are the forms status in form 6i

bjn

 Profile Answers by bjn Questions by bjn

• Apr 18th, 2008

The three form status are New ,QUERY, CHANGEDTARIYAL,BIJENDER

Answer Question  Select Best Answer

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

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

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

Arvind

• Oct 23rd, 2007

Lots of way for that, but you can try this search in home path file "registry" and u can set icon path there....

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

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

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

Rajeev Sadana

• Jun 28th, 2007

MID and Infra

Answer Question  Select Best Answer

We can restrict duplicate entries in the form cheak which coloum can be maintained uniquenessfor that coloumn item text write a trigger when_key_navigatedeclaree_empno number(5);cursor c is select * from emp;beginfor i in e_emp loopif e_empno= i.empno then dbms_output.put_line("already exist");end if;end loop;:empno=e_empno;end;