Answer / siva

Complex view

Answer / chandu

VIEW-- view is a virtual tables that are used in place of
actual tables.

Why merge statement is used inside the database?

0 Answers   ADITI,

---

What are the types of indexes that are present inside a database?

0 Answers   Abacus,

---

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

0 Answers   Miracle Software,

---

Its possible to use auto increment in oracle or not? If no means why?

1 Answers  

---

Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.

0 Answers  

---

---

Can we have a function Overloading with same number of arguments but with different return types of function

8 Answers   CybAge, Wipro,

---

What is ole db ado?

0 Answers  

---

Which is the best sorting method if i have to sort the students of Harvard University according to their first name?

1 Answers   CybAge,

---

What will happen non-clustered index will be created on clustered index?

0 Answers   Abacus,

---

What are indexes in oracle?

0 Answers   CGI,

---

First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9

0 Answers   IBM,

---

Clipper / DBF error

1 Answers  

---