What is private procedure oracle?

0 Answers  

---

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 Answers  

---

What is DTS and purpose of DTS ?

1 Answers   TCS,

---

where we have to use ON clause and where we have to use USING clause in JOINS

2 Answers  

---

consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?

1 Answers  

---

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

0 Answers   ESS,

---

Explain the different normalization forms?

0 Answers  

---

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

1 Answers   Wipro,

---

how to do daily transactions with out sql* loader control file regesterd in apps?

0 Answers   Arrow Electronics,

---

What is format trigger?

0 Answers  

---

Explain the use of record length option in exp command.

0 Answers  

---

What is self-referential integrity constraint ?

2 Answers   SunGard,

---