Explain about the case statement present in stored procedure?

0 Answers  

---

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name, price 101, LED Lights,200 102, 20 watt CFL Lights, 145 103, 30 watt CFL lights,155 Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence flat file product list has two column pro_name, price 20 watt tube light ,45 30 watt tube light ,60

1 Answers   TCS,

---

What is data in dbms?

0 Answers  

---

Explain what are triggers and rules?

0 Answers  

---

Can we assign Explicitly transaction to a rollback segment

1 Answers  

---

What is difference between database and website?

0 Answers  

---

Mention few case manipulation functions in sql

0 Answers  

---

Should database table names be capitalized?

0 Answers  

---

Compare non-clustered and clustered index

0 Answers  

---

Explain some of the uses of openedge architect features useful for a developer?

0 Answers  

---

What are different partitioning techniques in database?

0 Answers  

---

Explain the functionality of dml compiler.

0 Answers  

---