How do you remove duplicate records from a table?

0 Answers  

---

Types of locks in database ?

8 Answers   HCL, TCS, Tieto,

---

How to select all records from the table?

0 Answers  

---

What are conditional predicates?

0 Answers  

---

What does (+) mean in sql joins?

0 Answers  

---

---

What are local and global Indexes and where they are useful.

0 Answers  

---

how can we find the select statement is indexed or not?

3 Answers   CTS,

---

what is the difference between delete and truncate statement in sql? : Sql dba

0 Answers  

---

What is window clause?

1 Answers   TCS,

---

what is the difference between cursor FETCH and FOR LOOP ?

3 Answers   CG-VAK, Tech Mahindra,

---

What are all the different types of indexes?

0 Answers  

---

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,

---