How to return multiple records from procedure?

2 Answers  

---

What is the difference between function and procedure in pl/sql?

0 Answers  

---

Explain what is a subquery ?

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 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

0 Answers   TCS,

---

what is auto increment? : Sql dba

0 Answers  

---

---

How to trace the errors in pl/sql block code?

5 Answers   TCS,

---

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

0 Answers  

---

What is the location of pre_defined_functions.

0 Answers  

---

How do I copy a table in sql?

0 Answers  

---

What is a sql schema used for?

0 Answers  

---

What is dense_rank in sql?

0 Answers  

---

What are the ways on commenting in a pl/sql code?

0 Answers  

---