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

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 / shashidhar banda

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

Answer Posted / shashidhar banda

Answers:

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

Is This Answer Correct ?

11 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is difference between group above and group left report

3763

In what situation u create the BPA.

2154

how report can be generated if we have the database designed in oracle 10g?

1835

What is an implicit anchor and how is it a different form explicit anchor in a report builder?

1095

if u want to delete all these detail block etc what will happen in form

1928

all steps of bitmap report?

2304

What are the various configuration files that are used by oracle forms?

987

In what sequence do triggers get fired by oracle forms?

915

What is the difference between flex mode and confined mode?

990

Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

2173

what are the oracle forms services components include?

962

Why oracle forms required?

977

what are the new features introduced in oracle form services in 11g release 2?

982

did u received a single file or multiple files

1976

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1935