What is difference between truncate and delete ?

Discussion in 'Oracle' started by john125, Mar 15, 2011.

  1. john125

    john125 Banned

    Joined:
    Mar 11, 2011
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    Seo
    Location:
    India
    Home Page:
    http://www.indiamoverspackers.com/
    In oracle difference between turnacate and delete------
     
  2. xpi0t0s

    xpi0t0s Mentor

    Joined:
    Aug 6, 2004
    Messages:
    3,009
    Likes Received:
    203
    Trophy Points:
    63
    Occupation:
    Senior Support Engineer
    Location:
    England
    Re: What is difference between turnacate and delete ?

    see Page 19-67 of the 11.2 SQL Language Reference (or just search for TRUNCATE TABLE in whatever version of the SQL Language Reference you have handy).

    Also you might try Googling for "oracle difference truncate delete" which might return a few hits.
     
  3. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice