[DECLARE
Declarations 声明部分]
BEGIN
Plsql语句;
[EXCEPTION
handlers]
END;
--输出语句 ||拼接
dbms_output.put_line(内容);
--
DECLARE
a date;
v_s int;
abc varchar2(10);
v_g varchar2(100);
BEGIN
a:=sysdate;
dbms_output.put_line(a);
v_s:=&请你个老狗比输入点整数;
v_g:='&你可以来点汉字';
dbms_output.put_line(v_s);
dbms_output.put_line ('abc');
dbms_output.put_line(v_g);
--exception
end;
------------
declare
a varchar(50);
begin
a:='&输入他是什么颜色';
if a = 'red' or a = 'green'
then dbms_output.put_line('红色');
end if;
/* if a = 'green'
then dbms_output.put_line('绿色');
end if;*/
if a !='red' and a != 'green'
then dbms_output.put_line('其他颜色');
end if ;
--exception
end;
declare
v_color varchar(20);
begin
v_color :='&给个颜色';
case when v_color ='black'
then dbms_output.put_line('黑色');
when
v_color='red'
then dbms_output.put_line('红色');
when v_color !='black' and v_color !='red'
then dbms_output.put_line('别的颜色');
end CASE;
end;
------------------
1>记录类型的定义:
type xs is record(
sno number(5),
ssex varchar(20),
cno number(5)
);
type_name:记录类型名称
type emp_type is record(
ename varchar2(10),
job emp.job%type,
sal emp.sal%type
);
------------------
declare
a int :=50;
b int :=1;
begin
while b<=1000 loop
a:=a+b;
b:=b+1;
end loop;
dbms_output.put_line(a);
end;
--循环打印1 到9
begin
--for循环语句
for i in 1..9 loop
--循环体语句
dbms_output.put_line(' '||i);
end loop;
end;
select sal from emp
begin
for a in (select * from emp where sal=&sal)loop
dbms_output.put_line(a.empno);
end loop;
end;
begin
for c in (select * from sc where sno='&sno') loop
-----除了数字全部都要加两个单引号
dbms_output.put_line(','||c.score);
end loop;
end;
select * from sc1
select * from sc
declare
i number:=1;
begin
<<a>>
dbms_output.put_line(i);
i:=i+1;
if i<10 then
goto a;
end if;
end;
去掉_line不是不输出了,而是输出到内存,在下一次输出时一起出来