Does truncate table reset auto increment?

0 Answers  

---

What is the use of sqlerrd 3?

0 Answers  

---

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

2 Answers   Fintellix,

---

What are types of indexes in sql?

0 Answers  

---

how to see the create table statement of an existing 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 basic techniques of indexing?

0 Answers  

---

what is dbms? : Sql dba

0 Answers  

---

How is Oracle 10g helpful when compared to oracle 9i and what is grid computing

1 Answers   Flextronics,

---

What is left join in postgresql?

0 Answers  

---

What is the source code of a program?

0 Answers  

---

what is the difference between join and union? : Sql dba

0 Answers  

---