orders.sql

来自「Visual Basic + Oracle 9i数据库应用系统开发与实例（企业购」· SQL 代码 · 共 14 行

CREATE TABLE OSSMAN.Orders
  (OrderId	Number Primary Key,
   OrderType	Varchar2(20),
   ProId	Number,
   ProPrice	Number(15,2),
   ProNum	Number,
   ProAmount	Number(15,2),
   ClientId	Number, 
   OptDate	Char(10),
   EmpName	Varchar2(50),
   Stored	Number(1)
  )
TABLESPACE USERS;