What is materialized view. What are different methods of refresh?

0 Answers  

---

What are the three forms of normalization?

0 Answers  

---

If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

9 Answers   JPMorgan Chase,

---

How to get the 3rd column(i.e all the data along with the column name)in a table?

2 Answers   Logica CMG,

---

what is the difference between to_char and to_date functions?

10 Answers   Infosys,

---

What is pl sql variable?

0 Answers  

---

What are the different tcl commands in sql?

0 Answers  

---

what does the t-sql command ident_incr does? : Transact sql

0 Answers  

---

how to extract a unit value from a date and time? : Sql dba

0 Answers  

---

What is the purpose of normalization?

0 Answers  

---

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

0 Answers  

---

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---