Important Notes While Writing PLSQL Code

1. When you have a partition table, partition columns should not be null. Partition null columns cause an error.

2.When you want to drop a column from a big table, better use set column unuse instead of column drop.