代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/336594/12435133
sql createcheck.sql
ALTER TABLE "SCOTT"."STUDENT"
ADD (CONSTRAINT "研究生编号检查约束条件"
CHECK(student_id>=20020101 and student_id
www.eeworm.com/read/336594/12435135
sql createstudent.sql
CREATE TABLE "SCOTT"."STUDENT" (
"STUDENT_ID" NUMBER(8) NOT NULL,
"NAME" VARCHAR2(10) NOT NULL,
"PROFESSIONAL" VARCHAR2(10) NOT NULL,
"BI
www.eeworm.com/read/336594/12435139
sql selectview.sql
select "SCOTT"."STUDENT数据表视图"."STUDENT_ID",
"SCOTT"."STUDENT数据表视图"."NAME"
from "SCOTT"."STUDENT数据表视图"
www.eeworm.com/read/336594/12435142
sql insertdirector.sql
INSERT INTO "SCOTT"."DIRECTOR" ("DIRECTOR_ID" ,"NAME" ,"ZHICHENG" ,"ZHIWU" )
VALUES (200201 ,'张三丰' ,'博导' ,'系主任');
INSERT INTO "SCOTT"."DIRECTOR" ("DIRECTOR_ID" ,"NAME" ,"ZHICHENG"
www.eeworm.com/read/336594/12435146
sql updatestudent.sql
UPDATE "SCOTT"."STUDENT"
SET DIRECTOR_ID = 200204
WHERE STUDENT_ID = 20030103;
www.eeworm.com/read/336594/12435149
sql createview.sql
CREATE OR REPLACE VIEW "SCOTT"."STUDENT数据表视图" AS
select student_id,name
from scott.student WITH READ ONLY
www.eeworm.com/read/336594/12435152
sql deletestudent.sql
DELETE FROM "SCOTT"."STUDENT"
WHERE STUDENT_ID = 20030101;
www.eeworm.com/read/336594/12435154
sql updatedirector.sql
UPDATE "SCOTT"."DIRECTOR"
SET ZHIWU = '院长'
WHERE DIRECTOR_ID=200204;
www.eeworm.com/read/336594/12435156
sql createindex.sql
CREATE INDEX "SCOTT"."姓名字段索引"
ON "SCOTT"."STUDENT"("NAME")
TABLESPACE "INDX"