PL/SQL SQL Coding Guideline 34 - Avoid procedure or function calls between a SQL operation and an implicit cursor

條款三十四,避免在 SQL 語句運行與 implicit cursor 中間使用 procedure 或是 function。 ...

August 13, 2016 · 1 min · 170 words · Larry Nung

PL/SQL SQL CODING GUIDELINE 33 - Always close locally opened cursors

條款三十三,總是關閉開啟的游標。 ...

August 13, 2016 · 1 min · 134 words · Larry Nung

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() 判斷。 ...

August 13, 2016 · 2 min · 514 words · Larry Nung

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。 ...

August 7, 2016 · 1 min · 98 words · Larry Nung

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。 ...

June 8, 2016 · 1 min · 162 words · Larry Nung

PL/SQL SQL Coding Guideline 28 - Try to use ANSI join syntax if supported by your Oracle version

條款二十八,如果 Oracle 版本支援,請使用 ANSI-Join。 ...

June 7, 2016 · 1 min · 92 words · Larry Nung

PL/SQL SQL Coding Guideline 27 - Always use table aliases when your SQL statement involves more than one source

條款二十七,當使用多個來源做搜尋時,總是使用資料表別名。 ...

June 7, 2016 · 1 min · 93 words · Larry Nung

PL/SQL SQL Coding Guideline 26 - Always specify the target columns when executing an INSERT command

條款二十六,運行插入命令時總是指定塞入的欄位。 ...

June 7, 2016 · 1 min · 149 words · Larry Nung

PL/SQL amp; SQL CODING GUIDELINE 25 - Avoid using the LONG and LONG RAW data types

條款二十五,避免使用 LONG 與 LONG RAW 型態。 ...

December 18, 2015 · 1 min · 70 words · Larry Nung

PL/SQL amp; SQL CODING GUIDELINE 24 -Try to use boolean data type for values with dual meaning

條款二十四,當值只有兩種狀態時,試著使用 Boolean 型態。 ...

December 17, 2015 · 1 min · 127 words · Larry Nung