Loading…
Title

Database programming with sql - 7-1 oracle equijoin and cartesian ...

Description
Ansi/iso sql: 99 syntax. • legacy versions of oracle databases required joins to use. oracle proprietary join syntax, and many of these older.
/0
Full Text
Copyright © 2015, Oracle and/or its affiliates. All rights reserved.Database Programming with SQL7-1Oracle Equijoin and Cartesian ProductCopyright © 2015, Oracle and/or its affiliates. All rights reserved.DPS7L1Oracle Equijoin and Cartesian Product 3ObjectivesIn this lesson, you will learn to:• Name the Oracle proprietary joins and their ANSI/ISO SQL: 99counterparts• Construct and execute a SELECT statement that results in aCartesian product• Construct and execute SELECT statements to access data frommore than one table using an equijoin• Construct and execute SELECT statements that add searchconditions using the AND operator• Apply the rule for using table aliases in a join statementCopyright © 2015, Oracle and/or its affiliates. All rights reserved.DPS7L1Oracle Equijoin and Cartesian Product 4Purpose• The previous section looked at querying and returning datafrom more than one table in a relational database usingANSI/ISO SQL: 99 syntax.• Legacy versions of Oracle databases required j...