combine

Combine Sub Queries in Oracle PL/SQL

Combine Sub Queries in Oracle PL/SQL

Separate Sub Queries

Most of us do this when we need the most effective date with the most effective sequence.

Combined Sub Queries

This reduces the number of lookup operations the database has to do to one instead of the two in the previous example.

Leave a Reply

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

Enter Captcha Here : *

Reload Image

This site uses Akismet to reduce spam. Learn how your comment data is processed.