sequence 和索引函数调用
-------------------------------------------
重新编译索引
alter index index_name rebuild;
drop sequence sys_tempid
create sequence sys_tempid minvalue 1 maxvalue 999999999999999999 start with 1 increment by 1 cache 20;
--------------------------'fm去空格-----
SQL> select TO_CHAR(card_id.nextval,'00000000') from dual;
TO_CHAR(CARD_ID.NEXTVAL,'00000
------------------------------
00001424
---多出一个空格
SQL> select TO_CHAR(card_id.nextval,'fm00000000') from dual;
TO_CHAR(CARD_ID.NEXTVAL,'FM000
------------------------------
00001425
OK!
如果不指名格式，oracle会自动补充0或者空白把输出变成固定宽度的模式
fm前缀用来去除首尾的空字符或0
----包函数调用
SQL> declare boo boolean;
2 begin
3 boo:=pack_common.func_callback_card('01',336,'','','6');
4 end;
5 /
PL/SQL procedure successfully completed
----过程调用
SQL> exec call_func;
PL/SQL procedure successfully completed
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/9307930/viewspace-1029588/ ，如需转载，请注明出处，否则将追究法律责任。
