代码搜索：Sql
找到约 10,000 项符合「Sql」的源代码
代码结果 10,000
www.eeworm.com/read/475504/6790395
sql cursordefine.sql
set serveroutput on
declare
tempsal scott.emp.sal%type;
cursor mycursor is
select * from scott.emp
where sal>tempsal;
begin
tempsal:=800;
open mycursor;
end;
www.eeworm.com/read/475504/6790396
sql rowtypedefine.sql
Declare
mytable testtable%rowtype;
begin
select * into mytable
from tempuser.testtable
where recordnumber=88;
dbms_output.put_line(mytable.currentdate);
end;
www.eeworm.com/read/475504/6790398
sql isopenattribute.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;
www.eeworm.com/read/475504/6790400
sql createindexdirector.sql
CREATE INDEX "GRADUATEUSER"."导师姓名字段索引"
ON "GRADUATEUSER"."DIRECTOR_INFO"("NAME")
TABLESPACE "INDX"
www.eeworm.com/read/475504/6790406
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/475504/6790409
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/475504/6790415
sql createindexgraduate.sql
CREATE INDEX "GRADUATEUSER"."研究生姓名字段索引"
ON "GRADUATEUSER"."GRADUATE_INFO"("NAME")
TABLESPACE "INDX"
www.eeworm.com/read/475504/6790417
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/475504/6790425
sql createviewdirector.sql
CREATE OR REPLACE VIEW "GRADUATEUSER"."VIEW_DIRECTOR" AS
select *
from graduateuser.director_info WITH READ ONLY