代码搜索：Sql
找到约 10,000 项符合「Sql」的源代码
代码结果 10,000
www.eeworm.com/read/475504/6790182
sql insertstudent.sql
INSERT INTO "SCOTT"."STUDENT" ("STUDENT_ID" ,"NAME" ,"PROFESSIONAL" ,"BIRTHDAY" ,"DIRECTOR_ID" )
VALUES (20020101 ,'周芷若' ,'软件工程' ,TO_DATE('20-11月-1976', 'dd-Mon-yyyy HH:MI:SS AM') ,200201 );
INS
www.eeworm.com/read/475504/6790183
sql createcheck.sql
ALTER TABLE "SCOTT"."STUDENT"
ADD (CONSTRAINT "研究生编号检查约束条件"
CHECK(student_id>=20020101 and student_id
www.eeworm.com/read/475504/6790184
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/475504/6790185
sql selectview.sql
select "SCOTT"."STUDENT数据表视图"."STUDENT_ID",
"SCOTT"."STUDENT数据表视图"."NAME"
from "SCOTT"."STUDENT数据表视图"
www.eeworm.com/read/475504/6790186
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/475504/6790187
sql updatestudent.sql
UPDATE "SCOTT"."STUDENT"
SET DIRECTOR_ID = 200204
WHERE STUDENT_ID = 20030103;
www.eeworm.com/read/475504/6790188
sql createview.sql
CREATE OR REPLACE VIEW "SCOTT"."STUDENT数据表视图" AS
select student_id,name
from scott.student WITH READ ONLY
www.eeworm.com/read/475504/6790190
sql deletestudent.sql
DELETE FROM "SCOTT"."STUDENT"
WHERE STUDENT_ID = 20030101;
www.eeworm.com/read/475504/6790191
sql updatedirector.sql
UPDATE "SCOTT"."DIRECTOR"
SET ZHIWU = '院长'
WHERE DIRECTOR_ID=200204;