2008-04-08

SQL:returning A into B/函数参数默认值/手动更改表值

(1)returning A into B
update work_order wo
set wo.start_qty = nvl(wo.start_qty, 0) + 1
where wo.order_type = 'ATO'
and wo.exception_flag = 0
and wo.order_number = p_work_order
returning wo.start_qty into v_start_qty;
returning A into B:
A is the top DML of parameter
B is the we define variable.
Give A value to variable B

The fuction is to account for subsequent
(2)函数参数默认值
v_pid varchar(10) := get_pid(p_psn);

function get_pid(p_psn in varchar2,
p_valid in pls_integer := 1)

The p_valid in pls_integer := 1 effect is
When user the get_pid no p_valid then it default 1.
The p_valid¡¨ is dispensable
(3)手动更改表值
select s.*,rowid from student s;
评论
发表评论

提醒: 该博客已发表在公共论坛，博客所有留言会成为论坛回贴，留言请注意遵守论坛发贴规则

您还没有登录，请登录后发表评论

心似海
搜索本博客
博客分类
最近加入圈子
存档
最新评论