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
- 1 Answers
- 5776 Views
- Azri Solutions, I also Faced
- E-Mail Answers
Answer / shashidhar banda
Answers:
1)select avg(scost) from software where devin='ORACLE';
| Is This Answer Correct ? | 11 Yes | 1 No |
What are the two ways to incorporate images into a oracle forms application?
if u have one group can u create another from that
Can we use GO-BLOCK package in a pre-field trigger ?
how to load data into base tables
System.effective_date system variable is read only True/False
where do u put the report file
What are the Built-ins to display the user-named editor?
what are Navigational Triggers?
Is it possible to attach same library to more than one form?
What is a window?
What is a master detail relationship?
What is a Layout Editor?
Oracle General 
