Results 1 to 3 of 3

Thread: help

  1. #1
    Join Date
    Sep 2013
    Posts
    14

    Unanswered: help

    1. Modify the following SQL command so that the Rep_ID column is the PRIMARY KEY for the
    table and the default value of Y is assigned to the Comm column. (The Comm column
    indicates whether the sales representative earns commission.)
    CREATE TABLE store_reps
    (rep_ID NUMBER(5),
    last VARCHAR2(15),
    first VARCHAR2(10),
    comm CHAR(1) );

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    What have you tried? MySQL or Oracle (you've posted the same question twice in different topics).
    George
    Home | Blog

  3. #3
    Join Date
    Sep 2013
    Posts
    14

    mistake

    i ment to post only once

Posting Permissions

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