Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6484 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 |
how report can be generated if we have the database designed in oracle 10g?
How to change maximise or minimise the window in forms
How do you control the constraints in forms ?
how to pass 2 variables from one form to other form
how to pass 2 variables from one form to other form
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
Can we invoke one form from another in a multi-forms application?
What is summary column in Oracle Reports ?
What are the master-detail triggers?
When will ON-VALIDATE-FIELD trigger executed ?
What is the purpose of the product order option in the column property sheet?
did u received a single file or multiple files
Oracle General 
