How to Truncate Columns in Oracle

The Oracle PL-SQL "truncate" statement removes all rows from an Oracle table. You cannot roll back changes from the truncate statement, but it is faster than using the "delete" query statement. All records are removed from the table, so you must ensure that you do not need any of the table data before running the truncate statement.

Instructions

1. Open the Oracle Enterprise Manager software from the Windows program menu. Log in to your database and open the PL-SQL editor.

2. Create the truncate statement:

   truncate table

   Replace "table" with the name of the table you want to truncate.

3. Click "Run" to execute the statement. The truncate statement only requires a few seconds to run, even on large tables.

References

• Oracle: Truncate