what are the differences among rownum, rank and dense_rank? : Sql dba

0 Answers  

---

Explain architecture of sql server notification services?

0 Answers  

---

What is the difference between syntax error and runtime error?

0 Answers  

---

can i create trigger on synonym is it possible or not please help me

4 Answers   CGI,

---

what is 'mysqldump'? : Sql dba

0 Answers  

---

---

How does postgresql compare to mysql?

0 Answers  

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

What are analytic functions in sql?

0 Answers  

---

what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...

1 Answers   HCL, Satyam,

---

What are the sql versions?

0 Answers  

---

wht is the difference between sqlaserver2000 and 2005

1 Answers   ABC, IBM,

---

what is sql profiler

2 Answers   Fidelity,

---