Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Example of cross join

Posted By: Luana Fischer     Category: Oracle     Views: 2577

This article provides an example of cross join.

Code for Example of cross join in Oracle

Select c.cname,i.itemname from cust c 
crossjoin item I;

Output:

CNAME      ITEMNAME
--------   ------------

Ashish     Pendrive
Dhaval     Pendrive
Dipen      Pendrive
Hardik     Pendrive
Jigar      Pendrive
Ashish     Floppy
Dhaval     Floppy
Dipen      Floppy
Hardik     Floppy
Jigar      Floppy
Ashish     Cds
Dhaval     Cds
Dipen      Cds
Hardik     Cds
Jigar      Cds
Ashish     Mouse
Dhaval     Mouse
Dipen      Mouse
Hardik     Mouse
Jigar      Mouse
Ashish     Keyboard
Dhaval     Keyboard
Dipen      Keyboard
Hardik     Keyboard
Jigar      Keyboard
  
Share: 

 
 
 

Didn't find what you were looking for? Find more on Example of cross join Or get search suggestion and latest updates.

Luana Fischer
Luana Fischer author of Example of cross join is from Frankfurt, Germany.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!