代码搜索:Sql
找到约 10,000 项符合「Sql」的源代码
代码结果 10,000
www.eeworm.com/read/266899/11208954
sql createindex.sql
CREATE INDEX "SCOTT"."姓名字段索引"
ON "SCOTT"."STUDENT"("NAME")
TABLESPACE "INDX"
www.eeworm.com/read/266899/11208956
sql dropdirector.sql
DROP TABLE SCOTT.DIRECTOR CASCADE CONSTRAINTS;
www.eeworm.com/read/266899/11208959
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;
www.eeworm.com/read/266899/11208963
sql recordtypedefine.sql
set serveroutput on
declare
type myrecord is record(
myrecordnumber int,
mycurrentdate date);
srecord myrecord;
begin
select * into srecord from tempuser.testtable w
www.eeworm.com/read/266899/11208965
sql createsequence.sql
CREATE SEQUENCE "SCOTT"."TEMPSEQUENCE" INCREMENT BY 1 START WITH
1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE
CACHE 20 NOORDER
www.eeworm.com/read/266899/11208967
sql createsequencetable.sql
CREATE TABLE "SCOTT"."SEQUENCE_TABLE" ("NO" NUMBER(10) NOT NULL)
TABLESPACE "USERS"
www.eeworm.com/read/266899/11208968
sql createprocedure.sql
set serveroutput on
create or replace procedure tempuser.tempprocedure as
tempdate tempuser.testtable.currentdate%type;
begin
select currentdate
into tempdate
from testtable
www.eeworm.com/read/266899/11208973
sql rowcountattribute.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;