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.

Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?

3 Answers  

---

what is the difference between substr and instr function in oracle?

0 Answers  

---

Whether any commands are used for months calculation? If so, what are they?

0 Answers  

---

Does a Before form trigger fire when the parameter form is suppressed ?

1 Answers   Oracle,

---

How do you bind variables in oracle?

0 Answers  

---

---

How a tablespace is related to data files?

0 Answers  

---

what are pseudocolumns?

4 Answers  

---

what is the scenario where you take the database to NoArchivelog mode?

0 Answers  

---

What is the use of aggregate functions in oracle?

0 Answers  

---

interview questions with answer for cts

0 Answers   Cognizant,

---

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

3 Answers   HCL,

---

Why we choose emp number as primarykey?

4 Answers  

---