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   Azri Solutions,

---

how to load data into base tables

1 Answers  

---

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the smae block level ?

2 Answers  

---

what is integrity n how many integrity rules r there?

2 Answers   Convergys,

---

Can a field be used in a report wihtout it appearing in any data group?

1 Answers  

---

---

What is the difference between keystartup and pre-form ?

1 Answers  

---

Give the sequence of execution of the various report triggers?

1 Answers  

---

Explain how can you use the same lov for 2 columns?

0 Answers  

---

Where is the external query executed at the client or the server?

2 Answers   Wipro,

---

How can you format a character field in a report Layout editor ?

1 Answers   Convergys,

---

List the system variables related in Block and Field?

1 Answers  

---

how do u compile a form i.e .fmb file in Unix or in dos

0 Answers   HCL,

---