How to delete all the data from the table in sqlplus oracle

I want to delete all the data rows in the table, but without dropping the table. The delete statement has a where clause so I have to give one by one for each row. Is there any other way of deleting the whole data rows in the table?

This is Oracle and using开发者_JAVA技巧 sqlplus

You can try: TRUNCATE TABLE tableName

Truncate Table tablename

http://www.orafaq.com/faq/difference_between_truncate_delete_and_drop_commands

You can delete all records with delete from tablename also but truncate is much faster

It will be better that you drop constraint and then use Truncate command and after getting rid of data , apply the constraint again.

Try out Bulk deletion using FORALL. In that instead of deleting one row at time an entire bulk can be deleted in a single delete transaction.