代码搜索：Sql
找到约 10,000 项符合「Sql」的源代码
代码结果 10,000
www.eeworm.com/read/266899/11208975
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/266899/11208977
sql typedefine.sql
Declare
mydate tempuser.testtable.currentdate%type;
begin
commit;
end;
www.eeworm.com/read/266899/11208978
sql insertemp.sql
insert into scott.emp(empno,ename,sal) values(9000,'wang',2500);
www.eeworm.com/read/266899/11208980
sql basicdatatypedefine.sql
declare
age number(3):=26;
begin
commit;
end;
www.eeworm.com/read/266899/11208984
sql executeprocedure.sql
set serveroutput on
begin
tempuser.tempprocedure;
end;
www.eeworm.com/read/266899/11208986
sql insertsequencetable.sql
INSERT INTO SCOTT.SEQUENCE_TABLE(NO)
VALUES(SCOTT.TEMPSEQUENCE.NEXTVAL);
www.eeworm.com/read/266899/11208987
sql creategraduateprocess.sql
/*定义过程参数*/
create or replace procedure scott.graduateprocess(
tempzhengzhi in scott.graduate.zhengzhi%type,
tempyingyu in scott.graduate.yingyu%type,
tempzhuanye1 in scott.graduate.
www.eeworm.com/read/266899/11208989
sql creategraduate.sql
CREATE TABLE "SCOTT"."GRADUATE" (
"BH" NUMBER(10) NOT NULL,
"XM" VARCHAR2(10) NOT NULL,
"LB" VARCHAR2(10) NOT NULL,
"YINGYU" NUMBER(4, 1) NOT NULL,
"Z
www.eeworm.com/read/266899/11208990
sql mainprocess.sql
set serveroutput on
/*定义6个入口变量，分别对应graduate数据表中的专业课和总分分数线*/
declare
score1 number(4,1);
score2 number(4,1);
score3 number(4,1);
score4 number(4,1);
score5 number(4,1);
www.eeworm.com/read/266899/11208991
sql wrongplsql.sql
set serveroutput on
declare
tempno integer:=100;
begin
tempno=tempno+1;
end;