代码搜索:SqL
找到约 10,000 项符合「SqL」的源代码
代码结果 10,000
www.eeworm.com/read/293377/8296579
sql createindexdirector.sql
CREATE INDEX "GRADUATEUSER"."导师姓名字段索引"
ON "GRADUATEUSER"."DIRECTOR_INFO"("NAME")
TABLESPACE "INDX"
www.eeworm.com/read/293377/8296594
sql createtablemajorinfo.sql
CREATE TABLE "GRADUATEUSER"."MAJOR_INFO" ("ID" NUMBER(2) NOT NULL,
"NAME" VARCHAR2(30) NOT NULL,
CONSTRAINT "专业编号主码" PRIMARY KEY("ID"))
TABLESPACE "USERS"
www.eeworm.com/read/293377/8296605
sql creategraduateuser.sql
CREATE USER "GRADUATEUSER" PROFILE "DEFAULT"
IDENTIFIED BY "12345678" DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"
ACCOUNT UNLOCK;
GRANT UNLIMITED TABLESPACE TO "GRADUATE
www.eeworm.com/read/293377/8296618
sql createindexgraduate.sql
CREATE INDEX "GRADUATEUSER"."研究生姓名字段索引"
ON "GRADUATEUSER"."GRADUATE_INFO"("NAME")
TABLESPACE "INDX"
www.eeworm.com/read/293377/8296622
sql createtabledirectorinfo.sql
CREATE TABLE "GRADUATEUSER"."DIRECTOR_INFO" ("ID" NUMBER(10) NOT
NULL, "NAME" VARCHAR2(10) NOT NULL, "SEX" VARCHAR2(2) NOT
NULL, "ZHICHENG" VARCHAR2(20) NOT NULL, "ZHIWU" VARCHAR2(20)
www.eeworm.com/read/293377/8296659
sql createviewdirector.sql
CREATE OR REPLACE VIEW "GRADUATEUSER"."VIEW_DIRECTOR" AS
select *
from graduateuser.director_info WITH READ ONLY
www.eeworm.com/read/293377/8296673
sql createviewgraduate.sql
CREATE OR REPLACE VIEW "GRADUATEUSER"."VIEW_GRADUATE" AS
select *
from graduateuser.graduate_info WITH READ ONLY
www.eeworm.com/read/293377/8296681
sql createtablegraduateinfo.sql
CREATE TABLE "GRADUATEUSER"."GRADUATE_INFO" ("ID" NUMBER(10) NOT
NULL, "NAME" VARCHAR2(10) NOT NULL, "SEX" VARCHAR2(2) NOT
NULL, "TYPE" VARCHAR2(10) NOT NULL, "BIRTHDAY" DATE NOT NULL,
www.eeworm.com/read/293377/8296687
sql createviewmajor.sql
CREATE OR REPLACE VIEW "GRADUATEUSER"."VIEW_MAJOR" AS
select *
from graduateuser.major_info WITH READ ONLY
www.eeworm.com/read/293377/8296690
sql 432.sql
select emp.empno, emp.ename, emp.deptno, dept.dname,dept.loc
from scott.emp,scott.dept
where scott.emp.deptno=scott.dept.deptno;