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

3 Answers   TCS,

---

Find out the 3rd highest salary?

51 Answers   BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,

---

how to create a table index in mysql? : Sql dba

0 Answers  

---

what is bulk bind

4 Answers   TCS,

---

Can we debug stored procedure?

0 Answers  

---

---

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

---

Can we rename a column in the output of sql query?

0 Answers  

---

What is difference between select statement and cursor

3 Answers   JDA,

---

Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 Answers  

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

0 Answers  

---

What is rownum and rowid?

0 Answers  

---

What is the difference between function, procedure and package in pl/sql?

0 Answers  

---