Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

0 Answers  

---

what is the difference difference between procedure and packages

2 Answers   3i Infotech, Oracle,

---

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---

How to get employee name from employee table which is the fiveth highest salary of the table

20 Answers   Infosys, Rolta,

---

Why are sql stored procedures used?

0 Answers  

---

What are stuff and replace function?

0 Answers  

---

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

---

What is procedure and function in sql?

0 Answers  

---

which types of join is used in sql widely? : Sql dba

0 Answers  

---

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

---

What is Difference Between Unique and Primary Key Constraints?

0 Answers   Wipro,

---

What is the difference between left join and left outer join?

1 Answers  

---