PLSQL语句PLSQL语句.docx

PL/SQL语句的的使用Pl数据类型的定义与输出语句数据定义name varchar2(8);origin varchar2(20);数据输出语句name varchar2(8);origin varchar2(20);完整代码块declare name varchar2(8); origin varchar2(20); age number(2); begin name := 陈武; origin := 湖南邵阳城步; age := 19;dbms_output.put_line(name || ,来自 || origin || ,今年 || age || ‘岁’);end;开启服务器开关SQL set serveroutput on;PL/SQL如何抛出异常exception when others then dbms_output.put_line(除数不能为零！！！！);如何打印oracle中表格的信息declare num t_table.id%type; na t_table.name%type; add t_table.origin%type; money t_table.sal%type; begin select id,name,origin,sal into num,na,add,money from t_table where id=1;过程中的异常处理exception when no_data_found then dbms_output.put_line(no_data_found,errorr!!!!);程序的灵活性处理select id,name,origin,sal into num,na,add,money from t_table where id=a;（不能够使用id:=a）declarel_table t_table%rowtype;begin select * into l_table from t_table where id=m; dbms_output.put_line(l_table.id||l_table.name||l_table.oringin||l_table.sal);如何定义类型declare type table_rec is record( name t_table.name%type, origin t_table.origin%type, sal t_table.sal%type); l_table table_rec; begin select name,origin,sal into l_table from t_table where id=n;dbms_output.put_line(l_table.name||l_table.origin||l_table.sal);如何使用常量declare first constant number(2) default 22;begin dbms_output.put_line(‘first=’||first);end;实例：declare day_in_week constant number(1) default 7; week_in_month number(1) default 4; begin dbms_output.put_line(一个星期有||day_in_week||天); week_in_month := 5; dbms_output.put_line(一个月有||week_in_month||周); end;循环语句If-else语句declare l_table t_table%rowtype;level varchar2(15);begin select * into l_table from t_table where id =i;if l_table.sal5000 thenlevel = ‘高工资’;else level = ‘低工资’;end if;dbms_output.put_line(‘薪水等级’||level);end;For循环语句九九乘法表的编写：declare counter number(1);begin for i in 1..counter loop for j in 1..i loop dbms_output.put_line(j||’*’||i||’=’||j*i||’’); end loop; dbms_output.put_line