Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL

1 Answers  

---

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  

---

Explain oracle left join with an example?

0 Answers  

---

What are a collation and state the different types of collation sensitivity?

0 Answers  

---

i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions

4 Answers   CGI,

---

How do you handle duplicate records in a database?

1 Answers  

---

how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........

2 Answers   TCS,

---

How to use "if" statements on multiple conditions?

0 Answers  

---

Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?

1 Answers  

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

0 Answers   Mastek,

---

What are advantages of dateset in datastage?

0 Answers   iGate,

---

What are transaction isolation levels supported by oracle?

0 Answers  

---