代码搜索:SqL

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

代码结果 10,000
www.eeworm.com/read/266899/11208916

sql revokerole.sql

REVOKE "DBA" FROM "TEMPROLE";
www.eeworm.com/read/266899/11208921

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/266899/11208922

sql selectuserusers.sql

select * from sys.user_users;
www.eeworm.com/read/266899/11208923

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/266899/11208924

sql selectrowid.sql

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

sql selectdirector.sql

select * from scott.director;
www.eeworm.com/read/266899/11208927

sql truncatedirector.sql

truncate table scott.director drop storage;
www.eeworm.com/read/266899/11208929

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/266899/11208931

sql disableconstraint.sql

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

sql createdirector.sql

CREATE TABLE "SCOTT"."DIRECTOR" ( "DIRECTOR_ID" NUMBER(6) NOT NULL, "NAME" VARCHAR2(10) NOT NULL, "ZHICHENG" VARCHAR2(20) NOT NULL,