Is there anyway to enable parallel execution at the statment level when more than one table is involved in the query (ie. join)? I
don't want to set the parallelism at the table level.

Typically, a hint can be included to enable parallelism at the statement level (ie. SELECT /*+ PARALLEL (table1, 4) */ ), but how can this be enabled for EACH table in the FROM clause?

Thanks.