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
- 6460 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 can we call a URL from a menu (Oracle Forms 6i)?
how do u run sql loader
Is a Keystartup trigger fires as result of a operator pressing a key explicitly ?
What are the built-in used for getting cell values?
Is it possible to split the printpreviewer into more than one region?
What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?
Which of the two views should objects according to possession?
What is the use of Printer Definition file (PRT) in Reports ?
What is new_form built-in?
How to call Report from other Report ?
How can you format a character field in a report Layout editor ?
When do you use data parameter type?
Oracle General 
