Update a table from selecting another table

[padmam]

Hi DBA_ADMIN, 2nd May 2001 19:20 hrs chennai

As Chrislong has said to Use EXISTS is a good option with avoids the full table scan.There is by increasing the performance.

Cheers

Padmam