Answer / Rohit Diwakar

Union, Intersect, and Minus (or Except) are SQL Set Operators that allow you to combine, intersect, or exclude rows from two or more tables.

what is column? : Sql dba

1 Answers  

---

Explain dml and ddl?

1 Answers  

---

How do I run a pl sql program?

1 Answers  

---

What is a composite primary key?

1 Answers  

---

What is identity column in sql server?

1 Answers  

---

What is a temp table?

1 Answers  

---

What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,

---

What is the difference between row level and statement level trigger?

1 Answers  

---

What is primary key and foreign key?

1 Answers  

---

what is the use of friend function? : Sql dba

1 Answers  

---

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 Answers   Oracle,

---