Level Up

謙卑學習,持之以恆,才能不斷的Level Up


  • Home

  • Archives

  • Tags

  • Search
close

PL/SQL Tag

PL/SQL & SQL CODING GUIDELINE 34 - Avoid procedure or function calls between a SQL operation and an implicit cursor

08-13

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

08-13

PL/SQL & SQL CODING GUIDELINE 32 - Avoid using %NOTFOUND directly after the FETCH when working with BULK OPERATIONS and LIMIT clause. Use [array_name].COUNT() instead to check whether further FETCHs are needed

08-13

PL/SQL & SQL CODING GUIDELINE 31 - Always use %NOTFOUND instead of NOT %FOUND to check whether a cursor was successful

08-07

PL/SQL & SQL CODING GUIDELINE 29 - Try to use anchored records as targets for your cursors

06-08

PL/SQL & SQL CODING GUIDELINE 28 - Try to use ANSI-join syntax, if supported by your ORACLE version

06-07

PL/SQL & SQL CODING GUIDELINE 27 - Always use table aliases when your SQL statement involves more than one source

06-07

PL/SQL & SQL CODING GUIDELINE 26 - Always specify the target columns when executing an insert command

06-07

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

12-18

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

12-17
123…5
Larry Nung

Larry Nung

Level Up Blog (http://larrynung.github.io)

1635 posts
218 tags
RSS
GitHub Twitter LinkedIn SlideShare
© 2021 Larry Nung
Powered by Hexo
Theme - NexT.Mist