What is the use of sql trace?

0 Answers  

---

Do ddl statements need commit?

0 Answers  

---

Delete the emps whose salaries are lowest sals of their own dept.

5 Answers  

---

What jobs use sql?

0 Answers  

---

What is Difference Between Unique and Primary Key Constraints?

0 Answers   Wipro,

---

if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,

---

What are all the common sql functions?

0 Answers  

---

What is a unique constraint?

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,

---

Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

15 Answers   Satyam,

---

Do we need to create index on primary key?

0 Answers  

---

what is global temporary tables and how use that tables in pl/sql packages

1 Answers   Cap Gemini,

---