代码搜索:SqL
找到约 10,000 项符合「SqL」的源代码
代码结果 10,000
www.eeworm.com/read/389791/8502372
sql storeproid.sql
CREATE SEQUENCE OSSMAN.STOREPROID
MINVALUE 1
MAXVALUE 9999999999999999999999999999
START WITH 1
INCREMENT BY 1
CACHE 5;
www.eeworm.com/read/389791/8502375
sql protype.sql
CREATE TABLE OSSMAN.ProType
(TypeId Number Primary Key,
TypeName Varchar2(50),
UpperId Number
)
TABLESPACE USERS;
www.eeworm.com/read/389791/8502378
sql product.sql
CREATE TABLE OSSMAN.Product
(ProId Number Primary Key,
ProName Varchar2(50) NOT NULL,
TypeId Number,
ProStyle Varchar2(50),
ProUnit Varchar2(10),
ProPrice Number(15,2) DEFAULT 0
www.eeworm.com/read/389791/8502386
sql income.sql
CREATE TABLE OSSMAN.Income
(IncomeId Number Primary Key,
OriId Number,
CltId Number,
IncomeType Varchar2(20),
PayWay Varchar2(20),
Amount Number(15,2),
OptDate Char(1
www.eeworm.com/read/389791/8502388
sql ossman.sql
-- 创建用户
CREATE USER OSSMAN
IDENTIFIED BY OSSMAN
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;
-- 设置角色权限
GRANT CONNECT TO OSSMAN;
GRANT RESOURCE TO OSSMAN;
-- 设置系统权限
GRANT UNLIM
www.eeworm.com/read/389791/8502392
sql sales.sql
CREATE TABLE OSSMAN.Sales
(SaleId Number Primary Key,
SaleType Varchar2(20),
ProId Number,
ProPrice Number(15,2),
ProNum Number,
ProAmount Number(15,2),
ClientId Number,
www.eeworm.com/read/389791/8502395
sql client.sql
CREATE TABLE OSSMAN.Client
(ClientId Number Primary Key,
ClientName Varchar2(50) NOT NULL,
ClientType Number(1),
Bank Varchar2(50),
BankAccount Varchar2(50),
Contact Varchar2(30
www.eeworm.com/read/389791/8502401
sql proid.sql
CREATE SEQUENCE OSSMAN.PROID
MINVALUE 1
MAXVALUE 9999999999999999999999999999
START WITH 1
INCREMENT BY 1
CACHE 5;
www.eeworm.com/read/389791/8502405
sql orders.sql
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,
www.eeworm.com/read/389791/8502411
sql payid.sql
CREATE SEQUENCE OSSMAN.PAYID
MINVALUE 1
MAXVALUE 9999999999999999999999999999
START WITH 1
INCREMENT BY 1
CACHE 5;