代码搜索:Sql
找到约 10,000 项符合「Sql」的源代码
代码结果 10,000
www.eeworm.com/read/293377/8296410
sql selectrowid.sql
select rowid,student_id,name,professional,birthday,director_id
from scott.student;
www.eeworm.com/read/293377/8296414
sql truncatedirector.sql
truncate table scott.director drop storage;
www.eeworm.com/read/293377/8296417
sql testcheck.sql
INSERT INTO "SCOTT"."STUDENT" ("STUDENT_ID" ,"NAME" ,"PROFESSIONAL" ,"BIRTHDAY" ,"DIRECTOR_ID" )
VALUES (20010101 ,'纪晓芙' ,'软件工程' ,TO_DATE('15-7月 -1971', 'dd-Mon-yyyy HH:MI:SS AM') ,200201);
www.eeworm.com/read/293377/8296419
sql disableconstraint.sql
alter table scott.student
disable constraint "导师编号外码";
www.eeworm.com/read/293377/8296421
sql createdirector.sql
CREATE TABLE "SCOTT"."DIRECTOR" (
"DIRECTOR_ID" NUMBER(6) NOT NULL,
"NAME" VARCHAR2(10) NOT NULL,
"ZHICHENG" VARCHAR2(20) NOT NULL,
www.eeworm.com/read/293377/8296423
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/293377/8296425
sql createcheck.sql
ALTER TABLE "SCOTT"."STUDENT"
ADD (CONSTRAINT "研究生编号检查约束条件"
CHECK(student_id>=20020101 and student_id
www.eeworm.com/read/293377/8296427
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/293377/8296430
sql selectview.sql
select "SCOTT"."STUDENT数据表视图"."STUDENT_ID",
"SCOTT"."STUDENT数据表视图"."NAME"
from "SCOTT"."STUDENT数据表视图"