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 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? List its various types.
what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?
what are the oracle forms services components include?
What is the difference between flex mode and confined mode?
What is the difference between bind and lexical parameter?
Explain master-detail relationship with some examples.
What is responsibility and how u attach How to create user and how u attach with responsibility.
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
how do u compile a form i.e .fmb file in Unix or in dos
List the different types of columns in oracle reports.
What is an SQL FORMS ?
What is a canvas in oracle forms?
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables
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...