What is the difference between left outer join and left join?

0 Answers  

---

What is union and union all keyword in sql?

0 Answers  

---

What is primary key and unique key?

0 Answers  

---

What are the two different parts of the pl/sql packages?

0 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  

---

Why we use triggers in mysql?

0 Answers  

---

What is window clause?

1 Answers   TCS,

---

What is graph sql?

0 Answers  

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 Answers  

---

HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM

3 Answers  

---

What is sql*loader and what is it used for? : aql loader

0 Answers  

---

What is dense_rank in sql?

0 Answers  

---