how to rename an existing column in a table? : Sql dba

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 are the types of optimization?

0 Answers  

---

IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,

---

Can a procedure in a package be overloaded?

0 Answers   EXL,

---

What is difference between triggers and stored procedures. And advantages of SP over triggers ?

4 Answers   Microsoft, TCS,

---

What is foreign key and example?

0 Answers  

---

How many sql databases can you have on one server?

0 Answers  

---

What is an alias command?

0 Answers  

---

What is transaction control language (tcl)?

0 Answers  

---

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

---

What is oracle sql called?

0 Answers  

---