Looking for a Tutor Near You?

Post Learning Requirement »
x

Choose Country Code

x

Direction

x

Ask a Question

x

x
x
For better view click here
x
Hire a Tutor
DISCOVER

ORACLE SQL - Tutorial 1

Loading...

Published in: Oracle Training
697 Views

The documents contains information about various  functions and features of Oracle. 

Debarun S / Kolkata

10 years of teaching experience

Qualification: B.Tech

Teaches: Computer, Mathematics, Science, Chemistry, Computer Science, Physics, School Level Computer, Defence Exams, IBPS, Insurance Exams, SSC Exams

Contact this Tutor
  1. SQL LEFT JOIN Keyword SQL LEFT JOIN Keyword The LEFT JOIN keyword returns all records from the left table (tablel), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match. LEFT JOIN Syntax SELECT FROM tablel LEFT JOIN table2 ON tablel.column name = table2.c01umn name; Note: In some databases LEFT JOIN is called LEFT OUTER JOIN. LEFT JOIN tablel Demo Database table2 In this tutorial we will use the well-known Northwind sample database. Below is a selection from the "Customers" table: CustomerID CustomerName ContactName Address City PostalCode Country 1 2 3 Alfreds Futterkiste Ana Trujillo Emparedados y helados Antonio Moreno Taquerfa Maria Anders Ana Trujillo Antonio Moreno Obere Str. 57 Avda. de la Constituci6n 2222 Mataderos 2312 Berlin 12209 México 05021 D.F. México 05023 D.F. Germany Mexico Mexico
  2. And a selection from the "Orders" table: OrderlD CustomerID EmployeeID OrderDate 10308 10309 10310 2 37 77 7 3 8 1996-09-18 1996-09-19 1996-09-20 ShipperID 3 1 2 SQL LEFT JOIN Example The following SQL statement will select all customers, and any orders they might have: Example SELECT Customers.CustomerName, Orders.Order1D FROM Customers LEFT JOIN Orders ON Customers.Customer1D = Orders.Customer1D ORDER BY Customers.CustomerName•, Note: The LEFT JOIN keyword returns all records from the left table (Customers), even if there are no matches in the right table (Orders).

Need a Tutor or Coaching Class?

Post an enquiry and get instant responses from qualified and experienced tutors.

Post Requirement

Related Study Notes

Upload Study Notes

If you have your own Study Notes which you think can benefit others, please upload on LearnPick. For each approved Study Note you will get 100 Credit Points and 100 Activity Score which will increase your profile visibility.

Upload Now
Home > Study Notes > ORACLE SQL - Tutorial 1