Maclean Liu(刘相兵 发表于 2012-3-3 23:51:15

Basic Oracle SQL Tips

Basic Oracle SQL Tips
General SQL information Developers should know
Beginner level
Useful for all
Developers, DBAs & Designers
Taste of different features – SQL*Plus & PL/SQL
Look at in more detail (see References or Oracle doc)
Objectives:
Make you aware of Oracle SQL features
Improve programming style
Improve functionality & performance
Avoid pitfalls


Very important – No one likes sloppy code
Develop consistent SQL standard – Dev tools can help
Always have:
Header: program name, author, purpose, date, parms, tables
Document each SQL statement
Consistent indents, neatly line things up – equals, ANDs ORs
Suggestions:
Reserve words UPPER case (SELECT, FROM, WHERE)
User defined lower case (tables, columns) – also rem
Short alias names
Use courier new for e-mailing or documenting code
Apply good style to PL/SQL coding – use tools

oracle_bin 发表于 2012-3-7 22:19:59

thinks maclean

klby 发表于 2013-1-9 01:28:12

其实这是个好东西。

coolingverse 发表于 2013-1-9 16:43:11

谢谢ML的好资料

bj-jn 发表于 2013-1-31 17:13:00

学习了！

307679393 发表于 2013-2-7 10:13:20

好东西,就是太贵
页: [1]
查看完整版本: Basic Oracle SQL Tips