Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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 sqlplus

like image 610
Nubkadiya Avatar asked Jun 18 '10 01:06

Nubkadiya


1 Answers

You can try: TRUNCATE TABLE tableName

like image 134
Klinger Avatar answered Sep 18 '22 21:09

Klinger