1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
    In oracle difference between turnacate and delete------
     
  2. xpi0t0s

    xpi0t0s Mentor

    Joined:
    Aug 6, 2004
    Messages:
    3,012
    Likes Received:
    203
    Trophy Points:
    0
    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,287
    Likes Received:
    364
    Trophy Points:
    83

Share This Page