Oracle Forms Reports Interview Questions
Questions Answers Views Company eMail

Where do u define the select statement of the parameter? is it followed by the & variable ?

Zensar,

2 4055

What is user exit.?

IBM, Synergy, Zensar,

2 7319

How you define procure to pay?

PWC, Zensar,

1 8360

How do u give the list of values in bind parameter

Zensar,

1 4992

What are the types of trigger actions?

Zensar,

4 6092

Can you mention lexical parameter in select statement in the data model?

Zensar,

1 7614

What is 4-way match?

Zensar,

2 12211

What is responsibility and how u attach How to create user and how u attach with responsibility.

Zensar,

1602

In what situation u create the BPA.

Zensar,

1755

What is the difference between BPA AND Contract What are documents and test cases u followed

Zensar,

1926

How to create LOV in Oracle forms?

Accenture, Polaris,

2 31896

Table 1: STUDIES PNAME (VARCHAR), SPLACE (VARCHAR), COURSE (VARCHAR), CCOST (NUMBER) Table 2: SOFTWARE PNAME (VARCHAR), TITLE (VARCHAR), DEVIN (VARCHAR), SCOST (NUMBER), DCOST (NUMBER), SOLD (NUMBER) Table 3: PROGRAMMER PNAME (VARCHAR), DOB (DATE), DOJ (DATE), SEX (CHAR), PROF1 (VARCHAR), PROF2 (VARCHAR), SAL (NUMBER) PNAME – Programmer Name, SPLACE – Study Place, CCOST – Course Cost, DEVIN – Language the software or package is developed in, SCOST – Software Cost, DCOST – Development Cost, PROF1 – Proficiency 1 Use the above table definitions to answer the questions that follow. Find out the selling cost average for packages developed in Oracle. Display the names, ages and experiences of all programmers How much revenue has been earned through

Azri Solutions,

1 5732

How cost of one Forms created & Report Created?

TCS,

1 3942

How to create placeholder columns?

2 25218

What is the difference between formula column and place holder?

3 6333


Post New Oracle Forms Reports Questions

Un-Answered Questions { Oracle Forms Reports }

Explain master-detail relationship with some examples.

562


did u p prepared complex report

1586


What do you understand by lov and how can it be used?

560


What is an oracle report?

581


what is oracle forms?

578






What do you understand by lov?

541


Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

1838


how to send file attachment from oracle forms

2107


i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

2447


what is the difference between call_form, new_form and open_form?

693


If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

1793


Explain the different levels at which oracle form services interact.

586


why the Ctl file u put only in bin folder why not in other folder

1573


where do u put the report file

1622


in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1269