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 |
Explain the following file extention related to library?
from where do u receive the information to develop report
State any three mouse events system variables?
how to send file attachment from oracle forms
What are the menu items that oracle forms 4.0 supports?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
What is bind reference and how can it carate?
What are the various methods of performing a calculation in a report ?
What buil-in routines are used to display editor dynamicaly?
sequence of firing triggers for text-item is: 1)key_next_item, 2)when_validate_item, 3)post_text_item Now i change sequence of firing triggers like when_validate_item,key_next_item... Is it possible to change sequence? How?
HOW TO MAKE A MATRIX REPORT MANUALLY WITH SINGLE GROUPT QUERY OR MULTIPLE GROUP QUERY ?
What are the different types of Coordinations of the Master with the Detail block?