Oracle 11g R1 and Oracle 11g R2:
Hi all, i want to know whether for the below statements Parallelism works or not. This is for example sake only, so not putting any real table name or column name. And the table is partitioned by some column called partition_column.
UPDATE table_name SET column_name=some_value
WHERE partition_column= partition_value;
DELETE FROM table_name WHERE partition_column= partition_value;
In the above example please consider
partition_column = the column which is been partitioned