Table 1: STUDIES PNAME (VARCHAR), SPLACE (VARCHAR), COURSE (VARCHAR), CCOST (NU

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

Question Posted / vijjichadalavada

1 Answers
6520 Views
Azri Solutions, I also Faced
E-Mail Answers

Table 1: STUDIES PNAME (VARCHAR), SPLACE (VARCHAR), COURSE (VARCHAR), CCOST (NUMBER) Table 2: SOFTW..

Answer / shashidhar banda

Answers:

1)select avg(scost) from software where devin='ORACLE';

Is This Answer Correct ?

11 Yes

1 No

Post New Answer

More Oracle Forms Reports Interview Questions

what is integrity n how many integrity rules r there?

2 Answers Convergys,

can u call procedure or function is sq l query in reports

1 Answers

What is term? What is use of term?

1 Answers

how to create the triggers in the forms?

3 Answers

What built-in is used for changing the properties of the window dynamically?

1 Answers

what are the oracle forms services components include?

0 Answers

What are the built-ins used for finding Object ID function?

1 Answers

What is the difference between flex mode and confined mode?

0 Answers

how to pass 2 variables from one form to other form

1 Answers

I HAVE A REPORT LAYOUT LIKE THIS RUNDATE -FIELD DEPTNO-FIELD ------------------------------------------------------------ ------------------- EMPNO-----ENAME------SAL-----COMM----MGR----- ------------------------------------------------------------ ------------------ ------- ------------ -------- -------- -------- MY REQUIREMENT IS I WANT DEPTNO 10 VALUES IN ONE PAGE,DEPTNO 20 VALUES IN ONE PAGE,AND 30 IN ONE PAGE. I WANT LIKE THIS ....

4 Answers

what are different types of canvas views?

3 Answers

How to create LOV in Oracle forms?

2 Answers Accenture, Polaris,

For more Oracle Forms Reports Interview Questions Click Here