Answered Questions

  • Mar 10 2006
    05:53 PM
    93219
    34

    What is the difference between delete,drop and truncate?
    • Periyasamy

    Amit

    • Aug 28th, 2016

    Adding 2 cents 1) DELETE is DML command because it does not change data dictionary (Every command which changes data dictionary tables is called DDL command ) TRUNCATE is DDL command is changes stor...

    Ashakant Kendre

    • May 9th, 2016

    1>TRUNCATE is a DDL command whereas DELETE is a DML command. 2>TRUNCATE is much faster than DELETE. Reason: When you type DELETE. All the data get copied into the Rollback Tablespace first, then del...