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
- 6545 Views
- Azri Solutions, I also Faced
- E-Mail Answers
Answer Posted / shashidhar banda
Answers:
1)select avg(scost) from software where devin='ORACLE';
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What is an oracle report?
What is responsibility and how u attach How to create user and how u attach with responsibility.
Explain how can you use the same lov for 2 columns?
Is it possible to execute a dynamic sql from forms?
I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
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 ?
In what sequence do triggers get fired by oracle forms?
hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...
List the different types of columns in oracle reports.
what are bind variables?
from where do u receive the information to develop report
What is an SQL FORMS ?
What do you understand by lov and how can it be used?
