what is the difference between rownum pseudo column and row_number() function? : Sql dba

0 Answers  

---

Can we debug stored procedure?

0 Answers  

---

What are reports usually used for?

0 Answers  

---

What is procedure explain with example?

0 Answers  

---

what are the type of locks ? : Sql dba

0 Answers  

---

---

i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

3 Answers   Scope International,

---

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

0 Answers  

---

What are the differences between in and exists clause?

0 Answers  

---

What is trigger types of trigger?

0 Answers  

---

What is the use of count (*) in sql?

0 Answers  

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

1 Answers   IAS,

---

What is the difference between a database and a relational database?

0 Answers  

---