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!

create table (without primary key)

Discussion in 'General' started by monkey, Jun 5, 2014.

  1. monkey

    monkey Long Term Member

    Messages:
    156
    Likes Received:
    0
    Trophy Points:
    230
    Hello!
    Please, if I make a table and do not determine the primary key, does oracle "find" it alone, or is that a mistake directly?
    Many thanks!!!
     
  2. rajenb

    rajenb Forum Expert

    Messages:
    361
    Likes Received:
    114
    Trophy Points:
    655
    Location:
    Mauritius
    No, Oracle will not "find it alone". You have to define the Primary key.

    You may create a table without a Primary key; the statement will not fail (if it's that what you mean by "mistake").

    However, it's recommended to define one as far as possible.
     
    monkey likes this.
  3. monkey

    monkey Long Term Member

    Messages:
    156
    Likes Received:
    0
    Trophy Points:
    230
    Hello!
    Just created such the one, some statements work fine, wonder how far cen I get without the primary key at all?
    (It did not crass, and even my cat did nto die:d;))
    many thansk, peole