代码搜索：Sql
找到约 10,000 项符合「Sql」的源代码
代码结果 10,000
www.eeworm.com/read/293377/8296550
sql createtesttable.sql
CREATE TABLE "TEMPUSER"."TESTTABLE" ("RECORDNUMBER" NUMBER(4) NOT
NULL, "CURRENTDATE" DATE NOT NULL)
TABLESPACE "USERS"
www.eeworm.com/read/293377/8296557
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/293377/8296559
sql whilecontrol.sql
set serveroutput on
declare
number1 integer:=80;
number2 integer:=90;
i integer:=0;
begin
while number1
www.eeworm.com/read/293377/8296561
sql grantrole.sql
GRANT "RESOURCE" TO "TEMPUSER";
ALTER USER "TEMPUSER" DEFAULT ROLE ALL
www.eeworm.com/read/293377/8296563
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
www.eeworm.com/read/293377/8296569
sql cursordefine.sql
set serveroutput on
declare
tempsal scott.emp.sal%type;
cursor mycursor is
select * from scott.emp
where sal>tempsal;
begin
tempsal:=800;
open mycursor;
end;
www.eeworm.com/read/293377/8296571
sql rowtypedefine.sql
Declare
mytable testtable%rowtype;
begin
select * into mytable
from tempuser.testtable
where recordnumber=88;
dbms_output.put_line(mytable.currentdate);
end;
www.eeworm.com/read/293377/8296575
sql isopenattribute.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;