One of my developer deleted all the data from a table using 'delete from tablename' statement,how can I recover this data?

it happened in test db though, but want to get familiarize so that if such situation comes in production I can face it.

Alternative is to bring the data from prod and put it here. but I want to recover the lost data.

hope I am clear about what I need.

Thanks
Rajesh.

Have you heard of back up and restore ability?

I have a last night's backup but that is full db back up. I dont want to restore the entire Db but just recover the table's data.

Can I just restore this table from the full backup?

Sure. Restore the backup into a new database, export the missing table data, then load it into the old database.

Or you can restore selected tablespaces into a new db if you're using v9.x (check "Database rebuild" in the manual)

And when you are done review access on your tables.