Posted on Saturday, 20th June 2009 by captainmi2

Oracle SQL statement for truncating the table
This will removes all records in the database.
Truncate statement does not need the commit or rollback transaction, once executed, this will remove all the record in a table without chances of getting the previous record
For example:
Table A1 has 1000 records.
In SQL:

SQL> select count(1) as count_rec from [...]

Tags:
Posted in Basic, Oracle | Comments (0)