Explain autonomous transaction.

0 Answers  

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

How many types of keys are there in sql?

0 Answers  

---

Can we create view in stored procedure?

0 Answers  

---

Does view store data in sql?

0 Answers  

---

How can you tell the difference between an index and a view?

0 Answers  

---

how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently

1 Answers   Oracle, Wipro,

---

What is the sql case statement?

0 Answers  

---

Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.

1 Answers   CTS,

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

Why truncate is faster than delete?

0 Answers  

---

can i create trigger on synonym is it possible or not please help me

4 Answers   CGI,

---