随机产生id字符串 

guid varchar2(64);
guid := SYS_GUID();
return
　　'{'||substr(guid,1,8)||'-'||substr(guid,9,4)||
　　'-'||substr(guid,13,4)||'-'||substr(guid,17,4)
||'-'||substr(guid,21,12)||'}';

oracle中写个functions

posted @ 2011-09-22 14:06  魔都_XL  阅读(147)  评论(0)  编辑  收藏  举报