2015年Oracle认证考试辅导：Oracle数据库-PLSQL使用方法整理
发布时间：2010/3/13 11:27:56 来源：城市学习网 编辑：MOON
获取系统记录行数
go_block.
last_record.
row_count:=:system.trigger_record. system.cursor_record
execute_trigger.
设置鼠标状态
set_application_property.
raise form_trigger_failure.
显示错误
exception when others then
display_note.
decode
decode
decode
导出路径
0select * from t_parameter where f_name=’LeanERPTempDir’.
0select f_c_value from t_parameter where f_name =’WebServer1’.
合同附件
0select f_c_value from t_parameter where f_name=’purorderaccesspath’.
0select f_c_value from t_parameter where f_name=’purorderaccessurl’.
设置值列表
SET_ITEM_PROPERTY.
LIST_VALUES.
下拉列表
n:=populate_group.
populate_list.
:bLK_BUT.APPTYPE:=’0’.
调用另一模块
DECLARE
pl_id ParamList.
v_string varchar2.
v_itemname varchar2.
BEGIN
pl_id := Get_Parameter_List.
IF NOT Id_Null THEN
Destroy_Parameter_List.
END IF.
pl_id := Create_Parameter_List.
v_itemname:=:system.current_block’.’:system.current_item.
v_string:=name_in.
Add_Parameter.
Call_Form.
copy. Erase.
END.
批量处理
set_application_property.
SYNCHRONIZE.
first_record.
loop
null.
exit when :system.last_record = ’TRUE’.
next_record.
end loop.
set_application_property.
bell.
display_note.
采购计划关闭完毕!
对话框
IF display_stop <> alert_button1 THEN
RETURN.
END IF.
取得货币名称
begin
0select currencydesc
into v_currencydesc
from t_currency
where currencycode = c1.splymoneyflag.
exception when others then v_currencydesc := ’人民币（元）’.
end.
询问对话框-1
declare
return_value number.
