• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Sql » Cross Join in Oracle

Cross Join in Oracle

January 25, 2019 by techgoeasy Leave a Comment

This SQL tutorial focuses on cross join in Oracle, and provides explanations, examples

A CROSS JOIN  in Oracle is a JOIN operation that produces the Cartesian product of two tables.
i,e if one of the table is having 100 rows and another one 8 rows, then cross join will produce 800 rows

Here table emp has 14 rows and second table as 1 rows,so total 14 rows are returned.

we can create another example oracle table check this

So now total 28 rows are selected.

Cross Join does not let you specify a join clause. You may, however, specify a WHERE clause in the SELECT statement.

Cross join in another format can be written as

select a.* ,b.* from scott.emp a ,scott.example b ;

I hope you like this simple explanation of the cross join. Please do provide the feedback

Related Articles

self join in oracle with examples

oracle join syntax examples

What are Oracle Joins (Sql Joins)?

Various Joins Method in Oracle

Nested Loop Join in Oracle 11g

Filed Under: Oracle, Oracle Sql

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • find segment name from block in oracle
  • How the sql query is executed in Oracle
  • How to do sql query tuning in Oracle
  • How to enable 10053 trace in Oracle
  • How to find the bind variable of the sql id

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us