1b:["$","div",null,{"id":"main","children":[["$","div",null,{"id":"content","children":["$","div",null,{"id":"article-area","children":["$","div",null,{"id":"article-box","children":["$","div",null,{"className":"article","children":[["$","ul",null,{"className":"article-head","children":[["$","li",null,{"className":"publish","children":[["$","span",null,{"className":"month","children":["5月"," "]}],["$","span",null,{"className":"date","children":["09"," "]}],["$","span",null,{"className":"day","children":["週五"," "]}],["$","span",null,{"className":"year","children":"2008"}],["$","span",null,{"className":"time","children":"11:32"}]]}],["$","li",null,{"className":"title","id":"article-2019134441","data-site-category":"進修深造","data-site-category-id":8,"data-article-link":"https://oracled2k.pixnet.net/blog/posts/2019134441","children":["$","h2",null,{"children":["$","a",null,{"href":"https://oracled2k.pixnet.net/blog/posts/2019134441","children":"序號建立"}]}]}]]}],["$","div",null,{"className":"article-body","children":[["$","div",null,{"className":"article-content","children":[["$","div",null,{"className":"article-content-inner","id":"article-content-inner","suppressHydrationWarning":true,"dangerouslySetInnerHTML":{"__html":"

序號
1 增加用戶參數p_row_no,初始值為0

2 增加一個公式列CF_NO,在公式列的PL/SQL程序中這樣寫:
function CF_NOFormula return Number is
begin
:p_row_no := :p_row_no+1;
return(:p_row_no);
end;

另一種方法:在DATAMODEL中增加一列:1 as no,然後增加一公式列,對NO列求和

"}}],["$","div",null,{"className":"tag-container-parent","children":[["$","div",null,{"className":"tag-container article-keyword","data-version":"a","children":[["$","div",null,{"className":"tag__header","children":["$","div",null,{"className":"tag__header-title","children":"文章標籤"}]}],["$","div",null,{"className":"tag__main","id":"article-footer-tags","children":[]}]]}],["$","div",null,{"className":"tag-container global-keyword","children":[["$","div",null,{"className":"tag__header","children":["$","div",null,{"className":"tag__header-title","children":"全站熱搜"}]}],["$","div",null,{"className":"tag__main","children":[]}]]}]]}],["$","div",null,{"className":"author-profile","children":[["$","div",null,{"className":"author-profile__header","children":"創作者介紹"}],["$","div",null,{"className":"author-profile__main","id":"mixpanel-author-box","children":[["$","a",null,{"children":["$","img",null,{"className":"author-profile__avatar","src":"https://pimg.1px.tw/oracled2k/logo/oracled2k.png","alt":"創作者 oracleD2K 的頭像","loading":"lazy"}]}],["$","div",null,{"className":"author-profile__content","children":[["$","a",null,{"className":"author-profile__name","children":"oracleD2K"}],["$","p",null,{"className":"author-profile__info","children":"oracle園地"}]]}],["$","div",null,{"className":"author-profile__subscribe hoverable","children":["$","button",null,{"data-follow-state":"關注","className":"subscribe-btn member"}]}],["$","div",null,{"id":"pixnet-ad-article_bottom","children":" "}]]}]]}]]}],["$","p",null,{"className":"author","children":["oracleD2K"," 發表在"," ",["$","a",null,{"href":"https://www.pixnet.net","children":"痞客邦"}]," ",["$","a",null,{"href":"#comments","children":"留言"}],"(","0",")"," ",["$","span",null,{"className":"author-views","children":["人氣(",["$","span",null,{"id":"BlogArticleCount-223677942","children":"458"}],")"]}]]}],["$","div",null,{"id":"pixnet-ad-content-left-right-wrapper","children":[["$","div",null,{"className":"left"}],["$","div",null,{"className":"right"}]]}]]}],["$","div",null,{"className":"article-footer","children":[["$","ul",null,{"className":"refer","children":[["$","li",null,{"children":["全站分類：",["$","a",null,{"href":"#","children":"$undefined"}]]}]," ",["$","li",null,{"children":["個人分類：",["$","a",null,{"href":"#","children":"Oracle PL/SQL"}]]}]," "]}],["$","div",null,{"className":"back-to-top","children":["$","a",null,{"href":"#top","title":"back to the top of the page","children":"▲top"}]}]]}],["$","div",null,{"id":"pixnet-ad-after-footer"}]]}]}]}]}],["$","div",null,{"id":"links","children":["$","div",null,{"id":"sidebar__inner","children":[["$","div",null,{"id":"links-row-1","children":[["$","div","3183547,3183547",{"className":"hslice box","data-identifier":"pixSearch","id":"","children":[["$","h4",null,{"className":"box-title entry-title","suppressHydrationWarning":true,"dangerouslySetInnerHTML":{"__html":"文章搜尋"}}],["$","div",null,{"className":"box-text entry-content","suppressHydrationWarning":true,"dangerouslySetInnerHTML":{"__html":""}}]]}],["$","div","3183548,3183548",{"className":"hslice box","data-identifier":"pixLatestArticle","id":"hot-article","children":["$L29","$L2a"]}],"$L2b","$L2c","$L2d","$L2e","$L2f","$L30"]}],"$L31"]}]}]]}]

oracle園地

這裡是到處搜括來的ORACLE技術及文章,也有自己發表的文章,希望大家可以互相討論! PS-若有侵權,請告知哦.

序號建立

文章搜尋

最新文章

最新留言

文章精選

文章分類

Oracle Tools (3)

Oracle SQL (3)

教學影音檔 (1)

ORACLE ERP (8)

誰來我家

參觀人氣

姓名學