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 A1;
count_rec
--------
1000
SQL> truncate table A1;
After running the statement run again the count statement
SQL> select count(1) as count_rec from A1;
count_rec
--------
0
Tags: Oracle SQL statement for truncating the table
Posted in Basic, Oracle | Comments (0)
