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
Answer / shashidhar banda
Answers:
1)select avg(scost) from software where devin='ORACLE';
| Is This Answer Correct ? | 11 Yes | 1 No |
Can you attach an lov to a field at design time?
did u p prepared complex report
Can u explain me the Restricted and unrestricted procedure in Forms And reports and example as well ??
What is the content view and stacked view?
What are the various configuration files that are used by oracle forms?
What is a predefined exception available in forms 4.0?
What are the different file extensions that are created by oracle reports?
What is a predefined exception available in forms 4.0?
List out the oracle forms configuration files?
What is a record Group?
List the buil-in routine for controlling window during run-time?
What do you understand by oracle forms and why are they required?