PL/SQL SQL Coding Guideline 37 - Always use COALESCE instead of NVL if parameter 2 of the NVL function is a function call or a SELECT statement
條款三十七，如果 NVL 第二個參數是 function 呼叫或是 select 語句，使用 COALESCE 取代 NVL。 ...
PL/SQL and SQL Coding Guidelines
PL/SQL SQL CODING GUIDELINE 36 - Try to use CASE rather than DECODE
條款三十六，嘗試使用 CASE 而不要用 DECODE。 ...
PL/SQL SQL Coding Guideline 35 - Try to use CASE rather than an IF statement with multiple ELSIF paths
條款三十五，嘗試使用 CASE 語句取代多行 ELSIF 語句。 ...
PL/SQL SQL Coding Guideline 34 - Avoid procedure or function calls between a SQL operation and an implicit cursor
條款三十四，避免在 SQL 語句運行與 implicit cursor 中間使用 procedure 或是 function。 ...
PL/SQL SQL CODING GUIDELINE 33 - Always close locally opened cursors
條款三十三，總是關閉開啟的游標。 ...
PL/SQL SQL Coding Guideline 32 - Avoid using %NOTFOUND directly after the FETCH when working with BULK operations and LIMIT clause
條款三十二，當使用 BULK 與 LIMIT 操作時，避免直接在後面用 %NOTFOUND 判斷是否有資料處理，應改用 COUNT() 判斷。 ...
PL/SQL SQL Coding Guideline 31 - Always use %NOTFOUND instead of NOT %FOUND to check whether a cursor was successful
條款三十一，Always use %NOTFOUND instead of NOT %FOUND to check whether a cursor was successful。 ...
PL/SQL SQL Coding Guideline 29 - Try to use anchored records as targets for your cursors
條款二十九，Try to use anchored records as targets for your cursors。 ...
PL/SQL SQL Coding Guideline 28 - Try to use ANSI join syntax if supported by your Oracle version
條款二十八，如果 Oracle 版本支援，請使用 ANSI-Join。 ...
PL/SQL SQL Coding Guideline 27 - Always use table aliases when your SQL statement involves more than one source
條款二十七，當使用多個來源做搜尋時，總是使用資料表別名。 ...