Thing I really like in 11g: ADD COLUMN

In Oracle 11g if you want to alter add a column to a table and that column:
- allows NULLs and doesn't have DEFAULT value
- doesn't allows NULLS (NOT NULL column) and has DEFAULT value
- its a virtual column

you can do it without fear even if the tables are in use...it doesn't needs to lock then!