Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Example of cross join

Posted By: Luana Fischer     Category: Oracle     Views: 3262

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;


--------   ------------
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

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!