代码搜索:sql

找到约 10,000 项符合「sql」的源代码

代码结果 10,000
www.eeworm.com/read/336594/12435104

sql createprofile.sql

CREATE PROFILE "TEMPPROFILE" LIMIT CPU_PER_SESSION 1000 CPU_PER_CALL 1000 CONNECT_TIME 30 IDLE_TIME DEFAULT SESSIONS_PER_USER 10 LOGICAL_READS_PER_SESSION 1000 LOGICAL_READS_PER_CALL
www.eeworm.com/read/336594/12435107

sql selectuserusers.sql

select * from sys.user_users;
www.eeworm.com/read/336594/12435110

sql createrole.sql

CREATE ROLE "TEMPROLE" IDENTIFIED BY "temprole"; GRANT ALTER ANY INDEX TO "TEMPROLE" WITH ADMIN OPTION; GRANT SELECT ANY TABLE TO "TEMPROLE" WITH ADMIN OPTION; GRANT "CONNECT" TO "TEMPROLE"
www.eeworm.com/read/336594/12435112

sql selectrowid.sql

select rowid,student_id,name,professional,birthday,director_id from scott.student;
www.eeworm.com/read/336594/12435114

sql selectdirector.sql

select * from scott.director;
www.eeworm.com/read/336594/12435116

sql truncatedirector.sql

truncate table scott.director drop storage;
www.eeworm.com/read/336594/12435119

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/336594/12435123

sql disableconstraint.sql

alter table scott.student disable constraint "导师编号外码";
www.eeworm.com/read/336594/12435128

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/336594/12435131

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