Results 1 to 9 of 9
  1. #1
    Join Date
    Jan 2004
    Posts
    5

    Talking Unanswered: Difference between Column level and Table level

    Hello all,

    I'm new here, doing a degree in computer studies and using SQL within an Oracle environment, not sure if thats good or bad!

    I was wondering if anyone could explain the difference to me between column level and table level.

    Thank you very much.

    Chris

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    Generally speaking, the difference is granularity.

    Table level applies to the whole table.
    Column level applies to the column or columns within the table.

    Are you talking about constraints?
    Last edited by SkyWriter; 01-19-04 at 18:40.

  3. #3
    Join Date
    Jan 2004
    Posts
    5
    Originally posted by SkyWriter
    Generally speaking, the difference is granularity.

    Table level applies to the whole table.
    Column level applies to the column or columns within the table.

    Are you talking about constraints?
    Hi Sky Writer,

    Yeah I would like to know about table and column level constraints. Would you be able to help me or do you know anywhere where I may find related information. Thank you.

    Chris

  4. #4
    Join Date
    Jan 2004
    Posts
    5
    Originally posted by SkyWriter
    Generally speaking, the difference is granularity.

    Table level applies to the whole table.
    Column level applies to the column or columns within the table.

    Are you talking about constraints?
    Hi Sky Writer,

    Yeah I would like to know about table and column level constraints. Would you be able to help me or do you know anywhere where I may find related information. Thank you.

    Chris

  5. #5
    Join Date
    Jan 2004
    Posts
    370
    Below is a link to the documentation on constraints.
    It is free but you will need to register first.


    http://download-west.oracle.com/docs...g.htm#CNCPT022

  6. #6
    Join Date
    Jan 2004
    Posts
    5
    Hi Sky Writer,

    I couldn't open the link that you wrote down is there any other way of getting there? Thank you.

    Chris

  7. #7
    Join Date
    Jan 2004
    Posts
    370
    Originally posted by Chris90210
    Hi Sky Writer,

    I couldn't open the link that you wrote down is there any other way of getting there? Thank you.

    Chris
    Register for free at http://otn.oracle.com

  8. #8
    Join Date
    Jan 2004
    Posts
    5
    Sky writer,

    Thank you for your help finally found the page! I was wondering if you wouldn't mind quickly explaining to me the difference between null and not null. Thank you.

    Chris

  9. #9
    Join Date
    Jan 2004
    Location
    Hyderabad, India
    Posts
    37
    Not Null Constraint means , it will not allow any not null values, in other words, we need to enter some data other than null.

    Null means, we can have null values in the column..
    Regards
    Suneel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •