代码搜索：Sql
找到约 10,000 项符合「Sql」的源代码
代码结果 10,000
www.eeworm.com/read/475504/6790339
sql exceptiondefine.sql
set serveroutput on
declare
salaryerror exception;
tempsal scott.emp.sal%type;
begin
select sal into tempsal
from scott.emp
where empno=7566;
if tempsal
www.eeworm.com/read/475504/6790345
sql createresult.sql
CREATE TABLE "SCOTT"."RESULT" (
"BH" NUMBER(10) NOT NULL,
"XM" VARCHAR2(10) NOT NULL,
"LB" VARCHAR2(10) NOT NULL,
"YINGYU" NUMBER(4, 1) NOT NULL,
"ZH
www.eeworm.com/read/475504/6790353
sql executescottprocedure.sql
set serveroutput on
declare
myno scott.dept.deptno%type;
mydname scott.dept.dname%type;
myloc scott.dept.loc%type;
begin
myno:=10;
mydname:='';
myloc:='';
scott.tempproce
www.eeworm.com/read/475504/6790362
sql createtesttable.sql
CREATE TABLE "TEMPUSER"."TESTTABLE" ("RECORDNUMBER" NUMBER(4) NOT
NULL, "CURRENTDATE" DATE NOT NULL)
TABLESPACE "USERS"
www.eeworm.com/read/475504/6790378
sql foundattribute.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/475504/6790382
sql whilecontrol.sql
set serveroutput on
declare
number1 integer:=80;
number2 integer:=90;
i integer:=0;
begin
while number1
www.eeworm.com/read/475504/6790387
sql grantrole.sql
GRANT "RESOURCE" TO "TEMPUSER";
ALTER USER "TEMPUSER" DEFAULT ROLE ALL
www.eeworm.com/read/475504/6790390
sql forcontrol.sql
set serveroutput on
declare
number1 integer:=80;
number2 integer:=90;
i integer:=0;
begin
for i in 1..10 loop
number1:=number1+1;
end loop;
dbms_output.put_line('num