--求一次交易的Totalprice，一次交易后商品的库存量
DROP TABLE SM_SaleOrderList CASCADE CONSTRAINT;
CREATE TABLE SM_SaleOrderList(
TransactionID Number(10) NOT NULL UNIQUE,
TotalPrice Number(7,2) NOT NU
ALTER TABLE plsql101_person MODIFY (first_name NULL);
ALTER TABLE plsql101_person MODIFY (first_name NOT NULL);
ALTER TABLE plsql101_person MODIFY (last_name NULL);
-- NOT NULL CONSTRAINT
ALTER TABLE plsql101_person MODIFY (first_name NOT NULL);
ALTER TABLE plsql101_person MODIFY (last_name NOT NULL);
INSERT INTO plsql101_person VALUES (
'XL', 'Xaviera
drop table sm_emp_null;
create table sm_emp_null
(EmpID char(10) NOT NULL,
Name varchar2(10) NOT NULL,
salary number(8,2) NOT NULL,
TelNo char(8) NULL,
address varchar2(20)
);
insert
drop table sm_emp_null;
create table sm_emp_null
(EmpID char(10) NOT NULL,
Name varchar2(10) NOT NULL,
salary number(8,2) NOT NULL,
TelNo char(8) NULL,
address varchar2(20)
);
insert
create table class(
classid varchar2(10) not null,
begin_date date not null, --开课日期
end_date date not null, --截止日期
class_time date not null,---每天几点上课
total_time number(3,0) not null,---总课时
price
CREATE TABLE PARTS
(ID NUMBER(38)
,DESCRIPTION VARCHAR2(250) NOT NULL
,UNITPRICE NUMBER NOT NULL
,ONHAND NUMBER(38) NOT NULL
,REORDER VARCHAR2(40) NOT NULL
);
INSERT INTO parts
