代码搜索：Sql
找到约 10,000 项符合「Sql」的源代码
代码结果 10,000
www.eeworm.com/read/293377/8296434
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/293377/8296436
sql updatestudent.sql
UPDATE "SCOTT"."STUDENT"
SET DIRECTOR_ID = 200204
WHERE STUDENT_ID = 20030103;
www.eeworm.com/read/293377/8296439
sql createview.sql
CREATE OR REPLACE VIEW "SCOTT"."STUDENT数据表视图" AS
select student_id,name
from scott.student WITH READ ONLY
www.eeworm.com/read/293377/8296443
sql deletestudent.sql
DELETE FROM "SCOTT"."STUDENT"
WHERE STUDENT_ID = 20030101;
www.eeworm.com/read/293377/8296445
sql updatedirector.sql
UPDATE "SCOTT"."DIRECTOR"
SET ZHIWU = '院长'
WHERE DIRECTOR_ID=200204;
www.eeworm.com/read/293377/8296447
sql createindex.sql
CREATE INDEX "SCOTT"."姓名字段索引"
ON "SCOTT"."STUDENT"("NAME")
TABLESPACE "INDX"
www.eeworm.com/read/293377/8296450
sql dropdirector.sql
DROP TABLE SCOTT.DIRECTOR CASCADE CONSTRAINTS;
www.eeworm.com/read/293377/8296454
sql cursorfetch.sql
set serveroutput on
declare
tempsal scott.emp.sal%type;
cursor mycursor is
select * from scott.emp
where sal>tempsal;
cursorrecord mycursor%rowtype;
begin
tempsal:=800;