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

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

2334

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

2100

List out the oracle forms configuration files?

1130

What is the difference between flex mode and confined mode?

1111

What is a canvas in oracle forms?

1119

how do u place it in required folder

1987

what exactly u write in when_new_form_instance

3498

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2064

what is a package n what r the packages availbla in report

2160

What do you understand by oracle forms and why are they required?

1066

Is it possible to execute a dynamic sql from forms?

1120

What do you understand by oracle forms?

1115

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

2026

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1507

What is an oracle report? List its various types.

1024