What are the advantages of normalization?

0 Answers  

---

Write a query to display the current date in sql?

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 are the benefits of pl sql?

0 Answers  

---

what is definer rights invoke rights?

1 Answers  

---

---

What does “select count(1) from tab” result?

10 Answers   IBM,

---

Can i possible to see Table Details ? Ex : Table Name Date Time User Emp May/18/2010 12:59pm Scott

3 Answers  

---

What is trigger and types?

0 Answers  

---

Write a query to get 2nd maximum salary in an employee table ?

69 Answers   Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,

---

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

0 Answers  

---

In pl/sql, what is bulk binding, and when/how would it help performance?

0 Answers  

---

How does one load ebcdic data? : aql loader

0 Answers  

---