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
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
why the Ctl file u put only in bin folder why not in other folder
i am writing a query select EmpNo from Emp how can i call in after parameter form
what are the oracle forms services components include?
What is the difference between BPA AND Contract What are documents and test cases u followed
how do u place it in required folder
What is the difference between bind and lexical parameter?
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
What are the various configuration files that are used by oracle forms?
What is an SQL FORMS ?
in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory
What is a matrix report and how many minimum groups are required to prepare the same?
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 ?
What is an implicit anchor and how is it a different form explicit anchor in a report builder?