Explore BrainMass
Share

Explore BrainMass

    Solving an Oracle9i Database Problem

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Write the SQL command to create a table with the following traits:
     The table is named BEARS.
     The table has nine columns: BEAR_TAG, BEAR_NAME, TAGGED_DATE, WEIGHT, HEIGHT, BIRTH_DATE, LAST_KNOWN_LOCATION (allow 2000 bytes), PHOTO (a BLOB), and MAP (a BFILE).
     The table resides in the USERS tablespace and uses the default storage settings for the tablespace.
     The table is index-organized on the BEAR_TAG column.
     Overflow should begin after the BIRTH_DATE column.

    © BrainMass Inc. brainmass.com April 3, 2020, 3:57 pm ad1c9bdddf
    https://brainmass.com/computer-science/databases/solving-an-oracle9i-database-problem-93612

    Attachments

    Solution Preview

    CREATE TABLE BEARS
    ( BEAR_TAG VARCHAR2(50)
    , BEAR_NAME VARCHAR2(200)
    , TAGGED_DATE DATE
    , WEIGHT ...

    Solution Summary

    This solution helps with a problem about an oracle database.

    $2.19

    ADVERTISEMENT