Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Example of cross join

Posted By: Luana Fischer     Category: Oracle     Views: 3313

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!