Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to use Union of two select queries for a database export?

Maria CupinFeb 19 2025

I need to union two database querieres for an export job.

Any idea how this is formatted on a par file?

Comments

Rolla Mimy

Hi Maria,

You can add the QUERY parameter in your parfile.

dumpfile=test.dmp logfile=test.log directory=DIR QUERY= “select .. union ..”

Kinds

1 - 1

Post Details

Added on Feb 19 2025
1 comment
33 views