代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/457187/7332951
sql exceptionwithempno.sql
declare
emp_number integer:=&empno;
emp_name varchar2(10);
begin
select ename into emp_name from emp where empno=emp_number;
dbms_output.put_line('employee name is '||emp_name);
exception
when
www.eeworm.com/read/457187/7332952
sql casefuncs.sql
declare
a char(15);b char(15);c char(15);
begin
a:='computer';
b:='science';
c:='world';
dbms_output.put_line('first character as capital'||initcap(a));
dbms_output.put_line('concat a and c'||c
www.eeworm.com/read/457187/7332953
sql leftone.sql
DECLARE
A DATE;
B DATE;
BEGIN
A:=TRUNC(SYSDATE,'MONTH');
B:=ROUND(SYSDATE,'MONTH');
DBMS_OUTPUT.PUT_LINE('THE VALUE OF A IS '||A);
DBMS_OUTPUT.PUT_LINE('THE VALUE OF A IS '||B);
END;
/
www.eeworm.com/read/457187/7332954
sql matsfuncs.sql
www.eeworm.com/read/457187/7332955
sql insertvaluesintable.sql
declare
a number(2);
begin
for a in 1..10 loop
insert into s3 values(a,a*5,a*6,a*7,a*8);
end loop;
end;
/
www.eeworm.com/read/457187/7332957
sql factorial.sql
www.eeworm.com/read/457187/7332958
sql scholarship.sql
declare
total number;
begin
total:=&number;
if total>400 and total
www.eeworm.com/read/457187/7332959
sql name.sql
declare
x char(20);
begin
x:='&x';
if x in('amit','ajay','vinit','vikas') then
dbms_output.put_line('x is available in list');
else
dbms_output.put_line('x is not available in list');
end if;
www.eeworm.com/read/457034/7334825
sql ai.sql
CREATE TABLE fact
(
id int(11) not null auto_increment,
factid int(11) default null,
detail varchar(255) default null,
flag int(1) default null,
primary key(id)
)
CREATE TABLE rule
www.eeworm.com/read/457013/7335260
txt sql.txt
select * from List where (d1-d2=-1 and d2-d3=-1) or (d1-d2=1 and d2-d3=1)
选择所有顺子
select * from List where d1=d2 or d2=d3 or d1=d3
select * from list where s1=0
选择所有组3
select uid,d1+d2+d3 as Dsum,