代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/336594/12435199
sql typedefine.sql
Declare
mydate tempuser.testtable.currentdate%type;
begin
commit;
end;
www.eeworm.com/read/336594/12435203
sql insertemp.sql
insert into scott.emp(empno,ename,sal) values(9000,'wang',2500);
www.eeworm.com/read/336594/12435204
sql basicdatatypedefine.sql
declare
age number(3):=26;
begin
commit;
end;
www.eeworm.com/read/336594/12435208
sql executeprocedure.sql
set serveroutput on
begin
tempuser.tempprocedure;
end;
www.eeworm.com/read/336594/12435211
sql insertsequencetable.sql
INSERT INTO SCOTT.SEQUENCE_TABLE(NO)
VALUES(SCOTT.TEMPSEQUENCE.NEXTVAL);
www.eeworm.com/read/336594/12435215
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/336594/12435221
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/336594/12435227
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/336594/12435231
sql wrongplsql.sql
set serveroutput on
declare
tempno integer:=100;
begin
tempno=tempno+1;
end;
www.eeworm.com/read/336594/12435234
sql createscottprocedure.sql
Set serveroutput on
create or replace procedure scott.tempprocedure(
tempdeptno in scott.dept.deptno%type,
tempdname out scott.dept.dname%type,
temploc in out scott.dept.loc%type)as