Modify the following SQL command so that the Rep_ID column is the PRIMARY KEY for the table

Question:

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));

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Oracle 12c SQL

ISBN: 978-1305251038

3rd edition

Authors: Joan Casteel

Question Posted: