RT,顺便解释下红字的地方
set serveroutput on
DECLARE
price_to_hike NUMBER(6,2) := 20;
hiked_price NUMBER(6,2) := 0;
BEGIN
dbms_output.put_line('Price before hike ' || price_to_hike);
dbms_output.put_line('hiked_price before hike ' || hiked_price);
hike_prices (old_price => price_to_hike,
new_price => hiked_price);
dbms_output.put_line('price_to_hike after hike ' || price_to_hike);
dbms_output.put_line('hiked_price after hike ' || hiked_price);
END;
/
=========================================================================
Price before hike 20
hiked_price before hike 0
price_to_hike after hike 20
hiked_price after hike 21PL/SQL procedure successfully completed.
set serveroutput on
DECLARE
price_to_hike NUMBER(6,2) := 20;
hiked_price NUMBER(6,2) := 0;
BEGIN
dbms_output.put_line('Price before hike ' || price_to_hike);
dbms_output.put_line('hiked_price before hike ' || hiked_price);
hike_prices (old_price => price_to_hike,
new_price => hiked_price);
dbms_output.put_line('price_to_hike after hike ' || price_to_hike);
dbms_output.put_line('hiked_price after hike ' || hiked_price);
END;
/
=========================================================================
Price before hike 20
hiked_price before hike 0
price_to_hike after hike 20
hiked_price after hike 21PL/SQL procedure successfully completed.
解决方案 »
- 菜鸟问一个不同数据库之间连接的问题
- oracle入门问题
- linux下使用sqlplus插入数据的时候都是方框
- oracle中脏数据以及脏块是怎么来的,有啥区别啊?我都搞混了!
- 如何让函数返回CLOB类型的返回值?
- 大家推荐一本oracle的教材!
- 帮帮忙!一个小问题!select unitprice 产品单价 from stnprice; 我想在 产品单价 后面加一个(),请问?
- 一个关于data字段的问题
- 涉及到两行记录的金额计算问题??
- 在做RAID时选择分区ID进行CONFIG时报no driver responsing!该如何解决?
- 求一个关于学生课表查询的sql 语句,附代码
- impdp数据泵INCLUDE参数!!!!急!急!!!
如果你不知道那些参数的具体顺序可以采用这种方法hike_prices (old_price => price_to_hike,
new_price => hiked_price);
可能还有其他参数,而这两个参数也不是前两个参数,
按正常的写法还要设置其他的参数比较麻烦
令
参数old_price = price_to_hike,
参数new_price = hiked_price
假设有个过程
hs(a in number:=0,b in number:=0,c in number:=0,d in number:=0)
而我调用的时候想c=3,d=5,a和b采用缺省值
hs(c=>3,d=>5)等价于hs(0,0,3,5)