How do you remove duplicates without using distinct in sql?

0 Answers  

---

What are predefined functions in sql?

0 Answers  

---

Is a view faster than a stored procedure?

0 Answers  

---

what is the difference between implicit and explicit trigger

2 Answers   Tech Mahindra,

---

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,

---

Which function is used to return remainder in a division operator in sql?

0 Answers  

---

What is bind reference and how can it be created?

0 Answers  

---

Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL

1 Answers   Societe Generale,

---

how to select first 5 records from a table? : Sql dba

0 Answers  

---

What is sql not null constraint?

0 Answers  

---

What are the two different parts of the pl/sql packages?

0 Answers  

---

What are types of joins?

0 Answers  

---