Answer / nishi

Snapshots and Materialized view are used interchangeably as both are almost same. However, materialized view is having additional feature of query rewrite which is not in snapshot.

What are advantages of dateset in datastage?

0 Answers   iGate,

---

I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.

4 Answers  

---

hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..

1 Answers  

---

How to drop an existing table in oracle?

0 Answers  

---

if you ctreate table identity

0 Answers  

---

---

how the indexes are stored in the Oracle Database?

0 Answers  

---

How can windows applications connect to oracle servers?

0 Answers  

---

What is an oracle user role?

0 Answers  

---

how to genarate random numbers in oracle for particular row?

3 Answers  

---

Is the After report trigger fired if the report execution fails ?

0 Answers   Oracle,

---

what is the scripts in data base?

0 Answers  

---

What is merge in oracle?

0 Answers  

---