Results 1 to 12 of 12

Thread: Simple Question

  1. #1
    Join Date
    Dec 2003
    Posts
    148

    Unanswered: Simple Question

    Hi All.
    Simple question for you guys...I am looking at a bunch of tables that have the ID property checked (when I double click a table for its properties)
    Is that basically requiring a unique value for that column?
    What would be the Oracle equivlent to this?
    Thanks in advance everyone.

  2. #2
    Join Date
    Apr 2004
    Posts
    64
    It is an Identity field (like autonumber in Access). If you look in the design of the table it will tell you the ID seed and increment value. I think in Oracle they've got something called a sequence field which does the same...

    http://members.tripod.com/mdameryk/CreateSequence.htm
    Last edited by TechnicalAli; 06-28-04 at 13:34.

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Actually, SEQUENCE is a database object in Horacle.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    the "ID" property in EM just means that it's the Primary Key.

    Which may or may not have an IDENTITY property for a datatype.

    Are you migrating from SQL Server to Oracle?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Brett, c'mon, ID field that appears in Table Properties dialog box has a check mark in it ONLY if the field has IDENTITY property defined.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Sure enough...caught me when I didn't test it out....

    Shows how much I use EM...blasted thing...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You don't use EM?

    Philistine! Ludite! Neanderthal!
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    EN is quite useful... It has a nice little window that lets you monitor the distribution agents to be sure they are still running.

    EM also has some nice stuff that lets you use a GUI to do a "sniff test" on other things. That isn't the final word, but it can give you a quick overview of the current status of things.

    -PatP

  9. #9
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    So, it's a great Enterprise Monitor. All the Management pieces they tried to build with it though SUCK!!!!
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  10. #10
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I'm missing 6.5 EM with its Current Activity...
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  11. #11
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    I'm missing 6.5 EM with it's ability to restore a single table. Idiots still haven't given that back to us.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  12. #12
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I'm missing that fact that it won't refresh...that entry people think they're still in access, that you can do A LOT more by using information schema, that wizards suck, that I have to ween people of with a shovel (to the back the head)

    I'm waiting for the voice recoginition software

    "COMPUTER: This is The Captain, Security Clearence Aplha 1, Aplha 2, (oh I can't remember)...DROP DATABASE Master"
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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