代码搜索：Sql
找到约 10,000 项符合「Sql」的源代码
代码结果 10,000
www.eeworm.com/read/293377/8296459
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/293377/8296462
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/293377/8296464
sql createsequencetable.sql
CREATE TABLE "SCOTT"."SEQUENCE_TABLE" ("NO" NUMBER(10) NOT NULL)
TABLESPACE "USERS"
www.eeworm.com/read/293377/8296466
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/293377/8296472
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/293377/8296474
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);
www.eeworm.com/read/293377/8296477
sql typedefine.sql
Declare
mydate tempuser.testtable.currentdate%type;
begin
commit;
end;
www.eeworm.com/read/293377/8296479
sql insertemp.sql
insert into scott.emp(empno,ename,sal) values(9000,'wang',2500);
www.eeworm.com/read/293377/8296480
sql basicdatatypedefine.sql
declare
age number(3):=26;
begin
commit;
end;