Answer Posted / danish mahmood

Normalization is a systematic way of ensuring that a
database structure is suitable for general purpose querying
and free of certain undesirable characteristics—insertion,
update, and deletion anomalies that could lead to a loss of
data integrity.

How do you add a column to a table?

1012

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1604

---

what is view? : Sql dba

921

---

How does postgresql compare to mysql?

1003

---

What is cross join sql?

871

---

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

945

---

how to create a new table by selecting rows from another table in mysql? : Sql dba

1031

---

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1089

---

What is an implicit commit?

1006

---

Does mysql_real_escape_string prevent sql injection?

916

---

how to include character strings in sql statements? : Sql dba

1018

---

What is sqlservr exe?

949

---

what is the command line end user interface - mysql? : Sql dba

939

---

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

3954

---

How does pl sql work?

922

---