Answer / nandini sett

Outer join displays result set containing all the rows from
one table and the matching rows from another table. There
are three types of Outer Join -- Left Outer Join (All rows
of the left table and matchng rows of the right), Right
Outer Join (All rows of the right table and matching rows
of the left table) and Full Outer Join (All rows of both
tables).
In self join, table is joined with itself. One row
correlates with other rows in the same table. Hence a table
name with two alias names is used.
Difference between outer join and self join is that outer
join uses atleast two or more tables where one column is
common while self join uses only one table and two fields
of the same table.
Cartesian Product or cross join is between two tables where
each row from one table with each row of the other table.
If table A has 5 rows and table B has 10 rows then after
cross join the total number of rows would be 50.

can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?

2 Answers   Fujitsu,

---

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

How do you update a value in sql?

0 Answers  

---

Is sql similar to python?

0 Answers  

---

explain the difference between delete , truncate and drop commands? : Sql dba

0 Answers  

---

When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,

---

Will truncate release space?

0 Answers  

---

I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????

3 Answers   Infosys,

---

How do I remove duplicates in two columns?

0 Answers  

---

Does mysql support pl sql?

0 Answers  

---

what does myisamchk do? : Sql dba

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  

---