数据库建表练习

SQL> start C:\Users\lenovo\Desktop\my_tables.sql;

set serveroutput on;
declare
  a int:=9;
 b int:=0;
begin
     dbms_output.put_line('商是: '||a/b);
    dbms_output.put_line('finished!!!');
   exception
     when zero_divide then
       dbms_output.put_line('你做除法时，注意除数不能为0!!!');
        dbms_output.put_line('sqlcode||sqlerrm');
end;
declare
v_bonus salary.奖金%type;
v_empid employee.员工编号%type=20220107;
begin
end;