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
- 6521 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 a package n what r the packages availbla in report
difference between global n context sensitive segments?
How to create Drill down report?
What do you understand by oracle forms?
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
what are the new features introduced in oracle form services in 11g release 2?
Name the different triggers supported by oracle reports and their firing order.
what exactly u write in when_new_form_instance
all steps of bitmap report?
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
did u p prepared complex report
Explain the various types of oracle report?
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
how do u place it in required folder
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
