File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes joins and rollup Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "joins and rollup" Watch "joins and rollup" New topic
Author

joins and rollup

rama rajesh
Greenhorn

Joined: Jun 22, 2010
Posts: 28
How to identify which is a subquery and which is correlate subquery?i understand the difference between correlated subquery and subquery
(got information like subqeury executed only one and correlated subquery executes several times)

i read the rollup function, but i can't understand the functionality.
if anybody knows, please explain with simple example(rollup by more than 2 columns)
 
Don't get me started about those stupid light bulbs.
 
subject: joins and rollup