Selected Category: PL/SQL (3)

View Mode: Post List Post Summary

每次突然要用什麼函數, 都要上 Google 去找, 乾脆整理起來

不然每次都忘記要重找

 

(Read More...)

Posted by aloz0101 at 痞客邦 PIXNET Comments(1) Trackback(0) Hits(148)

▲top

DENSE_RANK() OVER(PARTITION BY XXX, YYY ORDER BY ZZZ )

RANK() OVER(PARTITION BY XXX, YYY ORDER BY ZZZ )

 

(Read More...)

Posted by aloz0101 at 痞客邦 PIXNET Comments(0) Trackback(0) Hits(137)

▲top

原本只知道 NVL 這個 Function, 可是當我有三個欄位需要判斷時就會很麻煩

NVL ( NVL ( A, B ), C )

上網 Google 了一下, 找到了 Coalesce

(Read More...)

Posted by aloz0101 at 痞客邦 PIXNET Comments(0) Trackback(0) Hits(174)

▲top