Difference between views and materialized views?

5 Answers   BirlaSoft,

---

what is isam? : Sql dba

0 Answers  

---

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

2 Answers   CG,

---

What is database sql?

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 a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

0 Answers  

---

what are aggregate and scalar functions? : Sql dba

0 Answers  

---

How to write pl sql program in mysql command prompt?

0 Answers  

---

How do you get all records from 2 tables. Which join do you use?

8 Answers   Microsoft,

---

give the syntax of grant and revoke commands? : Sql dba

0 Answers  

---

What are different types of triggers?

0 Answers  

---

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,

---