How to select random rows from a table?

0 Answers  

---

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

---

Can we create a trigger on view?

0 Answers  

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

what is global temporary tables and how use that tables in pl/sql packages

1 Answers   Cap Gemini,

---

Can you upgrade sql express to full sql?

0 Answers  

---

explain advantages of myisam over innodb? : Sql dba

0 Answers  

---

What is compound trigger?

0 Answers  

---

How to add new employee details in an employee_details table with the following details

0 Answers  

---

can we use out parameter in a function?Give an example.

4 Answers   Logica CMG, TCS,

---

What is bind variable in pl sql?

0 Answers  

---

What is primary key and foreign key?

0 Answers  

---