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
- 6552 Views
- Azri Solutions, I also Faced
- E-Mail Answers
Answer / shashidhar banda
Answers:
1)select avg(scost) from software where devin='ORACLE';
| Is This Answer Correct ? | 11 Yes | 1 No |
What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
I am using oracle developer suit(form 10g), On used ole2 objects to initialize excel and worksheet and on "BEFORE REPORT" i am printing report heading in excel using OLE2 objects only. if i run report from developer suit report builder it give output in excel normally and what expected but when ever i put same report on server and run report from application it gives error : " Terminated with error : <br> REP-1401 'before report': FATAL pl/sql error occured. ORA-43356; message 43356 not found; Product=RDBMS; facility = ORA." Please reply it is urgent
What are Most Common types of Complex master-detail relationships?
what is the sequence of firing triggers in forms?
How can a square be drawn in the layout editor of the report writer?
Is it possible to set a filter condition in a cross product group in matrix reports?
Explain the different levels at which oracle form services interact.
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
What are the different types of Record Groups?
What is a record group?
What is the purpose of the product order option in the column property sheet?
Oracle General 
