What is the diff between Truncate table / delete <table name> purge

3 Answers   TCS,

---

How to write a query to show the details of a student from students table whose

0 Answers  

---

display your age in months?

2 Answers  

---

What is nosql db?

0 Answers  

---

What is row_number () in sql?

0 Answers  

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

who introduced sql?

0 Answers  

---

what is the cursor and use of cursor in pl/sql ?

4 Answers  

---

What is the location of pre_defined_functions.

0 Answers  

---

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

---

How many types of primary keys are there?

0 Answers  

---

What is range partitioning?

0 Answers  

---