What is oracle Join?

What is oracle Join?

A join is a query that combines rows of two or more tables or views. To perform a JOIN, a join condition must be specified in WHERE clause. The result will be returned for those rows from both tables for which the join condition was met.

Example:
Joining results of employee and salary table:
SELECT employee.LastName, employee.FirstName, salary.amount
FROM employee
INNER JOIN salary
ON employee.P_Id=salary.P_Id
ORDER BY employee.LastName
What are the guidelines for joins?
Guidelines for joins - Join condition should ideally be written in the FROM clause.
What are the types of Join?
NON-EQUI Join, CARTESIAN Join, SELF Join, OUTER Join......
What a SELECT FOR UPDATE cursor represent?
The result of a PREPARE statement is a statement identifier. It is a data structure that represents the prepared statement text......
Post your comment