代码搜索：SqL
找到约 10,000 项符合「SqL」的源代码
代码结果 10,000
www.eeworm.com/read/293377/8296487
sql executeprocedure.sql
set serveroutput on
begin
tempuser.tempprocedure;
end;
www.eeworm.com/read/293377/8296490
sql insertsequencetable.sql
INSERT INTO SCOTT.SEQUENCE_TABLE(NO)
VALUES(SCOTT.TEMPSEQUENCE.NEXTVAL);
www.eeworm.com/read/293377/8296493
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/293377/8296500
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/293377/8296503
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/293377/8296506
sql wrongplsql.sql
set serveroutput on
declare
tempno integer:=100;
begin
tempno=tempno+1;
end;
www.eeworm.com/read/293377/8296509
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
www.eeworm.com/read/293377/8296518
sql datacompute.sql
set serveroutput on
Declare
result integer;
begin
result:=10+3*4-20+5**2;
dbms_output.put_line('运算结果是：'||to_char(result));
end;
www.eeworm.com/read/293377/8296522
sql notfoundattribute.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;