Oracle PL/SQL Interview questions


1. Can you delete a column in table with data in Oracle?

      Yes, we can

2 .Can you delete a column in table without data?

      Yes, we can

3. Can you delete a column in table with indexes in Oracle?

      We can delete a column with indexes. But if there is a Primary or foreign key present make sure,
foreign keys are deleted first and then column with Primary key.