Answer / Shivani Saxena

Uncommittable transactions in T-SQL refer to transactions that cannot be rolled back once they have started. They are also known as read-only or snapshot transactions.

What are the benefits of pl/sql packages?

1 Answers  

---

i want to display 1 to 10 numbers using one select statement.

18 Answers   HCL, Nyros, Oracle,

---

what is self join and what is the requirement of self join? : Sql dba

1 Answers  

---

Can we insert data in view?

1 Answers  

---

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

5 Answers   Deloitte, Ness Technologies,

---

How can we implement rollback or commit statement in a trigger?

1 Answers  

---

what is 'mysqlcheck'? : Sql dba

1 Answers  

---

How to fix oracle error ora-00942: table or view does not exist

1 Answers  

---

What are some emotional triggers?

1 Answers  

---

what is meant by urlencode and urldocode? : Sql dba

1 Answers  

---

State few characteristics of pl/sql?

1 Answers  

---

How can you create an empty table from an existing table?

1 Answers  

---