How to Get Back Dropped Column of A Table?

If flashback is enable then you can simply use it to recover your table column.

You mean to say incomplete recovery there is not another way? I can not flashback on column level like flashback table (from recyclebin ). If droped table goes to recyclebin and updated(old) rows goes to undo what about droped column (where it goes)?

Yes incomplete recovery. well flashback will not work if you perform ddl in between. If you want to recover your column then use flashback which is use to recover your table consist of that column. And as per my knowledge ddl statements like dropping column does go anywhere as it's autocommited.

Hey Abhijit when did you drop your table column. If it is very recent then just check with your db you can get it back by using logminer.

You may use the timestamp query or use flash back query or recyclebin query.

If your db is in flashback mode then use flashback query. You'll easily can get it.

If your db is not in flash backmode then its better to use point in time recovery. If your db is not in flash backmode then its better to use point in time recovery.

Just use this below given:
Flash back table tablename;
For table flash back
***nooo need to enble flashback**
Its work above