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) );
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) );
My resulte for this bleow question came error. The top result is for the store_reps.
Q-Create a table named BOOK_STORES to include the columns listed in the following chart:
Create table BOOK_STORES(store_id NUMBER(8),
constraint store_id_pk PRIMARY KEY(store_id),
name VARCHAR2(30),
constraint name_uk UNIQUE(name),
contact VARCHAR2(30),
rep_id VARCHAR2(5));
constraint store_id_pk PRIMARY KEY(store_id),
Error at line 2
Trending now
This is a popular solution!
Step by step
Solved in 2 steps