1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Need ur help reg codd rule,rowid,rownum

Discussion in 'SQL PL/SQL' started by laxman, Jul 3, 2009.

  1. laxman

    laxman Forum Expert

    Messages:
    144
    Likes Received:
    0
    Trophy Points:
    230
    Location:
    MUMBAI
    I have two three point to discuss here it is

    1> How many codd rules currently oracle 9i and 10 g following?
    2>Diff betwn ROWID and rownum
    3>if i delete any particular row whether rowid also got deleted identifying that row.

    kindly help me on this issue

    Regards
    Laxman
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    It looks like home work/interview question . Just google and try yourself and let us know whether you got the answer you were looking for.

    Btw, Oracle satisfies 11 out of 12 codd's rule (though not completely) . The Rule No.12 is not satisfied by Oracle. And None of the existing database satisfies all the 12 rules.


    Not sure what is actually your question no.3 ? Anyway google it.