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
You can try: TRUNCATE TABLE tableName
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With