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
- 6548 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 is latest version in reports
What is relation between the window and canvas views?
The join defined by the default data link is an outer join yes or no?
What are the built_in used to trapping errors in forms 4?
What is a master detail relationship?
What are built-ins used for Processing rows?
EXIT_FORM is a restricted package procedure ?
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
What is a text list?
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
What are the triggers associated with the image item?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?
Oracle General 
