代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/336594/12435158
sql dropdirector.sql
DROP TABLE SCOTT.DIRECTOR CASCADE CONSTRAINTS;
www.eeworm.com/read/336594/12435165
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/336594/12435169
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/336594/12435172
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/336594/12435175
sql createsequencetable.sql
CREATE TABLE "SCOTT"."SEQUENCE_TABLE" ("NO" NUMBER(10) NOT NULL)
TABLESPACE "USERS"
www.eeworm.com/read/336594/12435178
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/336594/12435191
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;
www.eeworm.com/read/336594/12435193
sql inserttesttable.sql
set serveroutput on
declare
maxrecords constant int:=100;
i int :=1;
begin
for i in 1..maxrecords loop
insert into tempuser.testtable(recordnumber,currentdate)
values(i,sysdate);