Oracle PL/SQL Best Practices [ILLUSTRATED]

最新推荐文章于 2016-07-29 17:52:00 发布
最新推荐文章于 2016-07-29 17:52:00 发布
阅读量875 收藏
点赞数
分类专栏： Oracle 文章标签： oracle features reference 出版 each sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/topmvp/article/details/3591701
版权
版权声明：原创作品，允许转载，转载时请务必以超链接形式标明文章原始出版、作者信息和本声明。否则将追究法律责任。 http://blog.csdn.net/topmvp - topmvp
Handbook for users of Oracle 8i and SQL, with practical answers to common tough issues dealt with by developers. Summarizes approximately 120 best practices in all and features a pull-out reference card listing all of the best practices featured in the text. Each best practice includes an example that features it in context.
http://rapidshare.com/files/97129592/0596514107.zip
http://depositfiles.com/files/3934368
topmvp
关注
专栏目录
oracle pl/sql
gaston的博客
01-25 219
查询数据库中的所有用户------------select * from dba_users; 锁住用户---------------------------------alter user TEST_SELECT account lock; 给用户解锁------------------------------alter user TEST_SELECT account unlock; 建...
Oracle-PL/SQL
SoftStar的专栏
11-24 758
实验1：写一个PL/SQL，输出”Hello World”。 begin dbms_output.put_line('Hello World'); end; 实验2：写一个PL/SQL，查询emp表的工资，输入员工编号，根据编号查询工资，如果工资高于3000无，则显示高工资，如果工资大于2000元，则显示中等工资，如果工资小于2000元，则显示低工资。 declare v_sal
Oracle PL SQL Best Practices(2nd) 无水印pdf
09-29
Oracle PL SQL Best Practices(2nd) 英文无水印pdf 第2版 pdf所有页面使用FoxitReader和PDF-XChangeViewer测试都可以打开 本资源转载自网络，如有侵权，请联系上传者或csdn删除 本资源转载自网络，如有侵权，请联系上传者或csdn删除
Oracle PL/SQL Best Practices
01-08
Oracle PL/SQL Best Practices Preface When I first started writing about the Oracle PL/SQL language back in 1994, the only sources of information were the product documentation (such as it was) and the occasional paper and presentation at Oracle User Group events. Today, there are at least a dozen books that focus exclusively on PL/SQL, numerous products that help you write PL/SQL code (integrated development environments, knowledge bases, etc.), training classes, and web sites. And the community of PL/SQL developers continues to grow in size and maturity, even with the advent of Java. Access to information about PL/SQL is no longer the challenge. It can, on the other hand, be difficult to make sense of all the new features, the numerous resources, the choices for tools, and so on. When it comes to writing a program or an entire application, developers have, over and over again, expressed the desire for advice. They ask: · How should I format my code? · What naming conventions, if any, should I use? · How can I write my packages so that they can be more easily maintained? · What is the best way to query information from the database? · How can I get all the developers on my team to handle errors the same way? So many questions, so much burning desire to write code well, and so few resources available to help us do that. So I decided to write a book that offers a concentrated set of "best practices" for the Oracle PL/SQL language. The objective of this book is to provide concrete, immediately applicable, quickly located advice that will assist you in writing code that is readable, maintainable, and efficient. You will undoubtedly find recommendations in this book that also appear in some of my other books; I hope you will not be offended by this repetition. It's simply impossible to offer in a single book everything that can and should be written about the Oracle PL/SQL language. While I plan to reinforce these best practices in the appropriate places in my other tex
Oracle PL/SQL best practice
11-27
This PPT is about the most important features and critical best practices presented by Steven Feuerstein, a guru of Oracle PL/SQL language.
Oracle PL/SQL Best Practices, Second Edition [ILLUSTRATED] (Paperback), Oct.2007.eBook-BBL
Linhanshi Blog
03-05 1392
TITLE : Oracle PL/SQL Best Practices, Second Edition [ILLUSTRATED] (Paperback)AUTHOR : by Steven Feuerstein (Author)PUBLISHER : OReilly Media publisherISBN : 0596514107EDITION : 2ndPUB DATE : October
SQL Server - Best Practices
chuifuhuo6864的博客
07-29 85
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx 转载于:https://my.osch...
PL_SQL_Best_Practices
09-30
在这一章节中，Steven Feuerstein——一位在Oracle PL/SQL领域享有盛誉的专家，提炼出了他多年编程、写作和教学的经验，形成了一系列PL/SQL“最佳实践”。这些最佳实践旨在帮助程序员编写出可读性强、易于维护且高效...
oracle best practice 读书笔记(持续更新)
rob's blog
04-16 241
持续更新。 成功的软件项目的特点（优先级排序）: 1 满足用户的需求 2 可维护性 3 性能好 程序员应该遵循的规范： 1 尽量使用自动排版工具，对工具进行定义满足自己的需求 2 建立一套变量，函数，过程等命名规范 3 建立模板使程序员能方便地(最后是自动地)根据模板产生文档和代码 4 编写出具有自解释的代码，同时添加必要的注释 5 添加必要注释的地方包括 - 程...
SQL Server XML性能优化(Best Practices)
weixin_30415113的博客
04-23 151
1. XML数据模型XML存储与处理查询的性能取决于数据库的设计与XML数据的结构与粒度。是否要使用XML数据模型，看你 是不是有半结构化的数据，需要保留文档结构与层次结构的标记语言数据，或可变的结构。 1.1 标记 Markups同样的数据可以以不同的方式来标记，视内容（element值）与元数据信息（attribute值）。越具体的 element名越易于阅读，且对生成有效的查询计划有帮...
Top 20+ MySQL Best Practices
周自信的技术博客
09-11 708
Top 20+ MySQL Best Practices Burak Guzel on Nov 25th 2009 with 196 comments Database operations often tend to be the main bottlen
Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions
TopMVP
08-06 4998
Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions is the definitive book if youre a eveloper or DBA who works with Oracle-driven database applications. This fully r
OCP Oracle Database 11g Administration II Exam Guide: Exam 1Z0-053
TopMVP
07-05 2999
版权声明：原创作品，允许转载，转载时请务必以超链接形式标明文章原始出版、作者信息和本声明。否则将追究法律责任。http://blog.csdn.net/topmvp - topmvpA Fully Integrated Study System for OCP Exam 1Z0-053Prepare for the Oracle Certified Professional Oracle
OCA Oracle Database 11g: Administration I Exam Guide
TopMVP
02-25 1264
版权声明：原创作品，允许转载，转载时请务必以超链接形式标明文章原始出版、作者信息和本声明。否则将追究法律责任。http://blog.csdn.net/topmvp - topmvpA Fully Integrated Study System for OCA Exam 1Z0-052Prepare for the Oracle Certified Associate Oracle Dat
OCA Oracle Database 11g: SQL Fundamentals I Exam Guide
TopMVP
02-25 1027
版权声明：原创作品，允许转载，转载时请务必以超链接形式标明文章原始出版、作者信息和本声明。否则将追究法律责任。http://blog.csdn.net/topmvp - topmvpA Fully Integrated Study System for OCA Exam 1Z0-051Prepare for the Oracle Certified Associate Oracle Dat
Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning
TopMVP
10-31 822
版权声明：原创作品，允许转载，转载时请务必以超链接形式标明文章原始出版、作者信息和本声明。否则将追究法律责任。http://blog.csdn.net/topmvp - topmvpIdentify and Resolve System Bottlenecks QuicklyTroubleshoot, diagnose, and optimize your Oracle database
Oracle PL/SQL 存储过程开发实战与练习
Oracle PL/SQL程序开发练习是一系列针对Oracle数据库管理系统（Oracle9i）中的PL/SQL基础功能的实践性学习材料。PL/SQL是Oracle数据库中的一种结构化查询语言（Structured Query Language）扩展，它结合了SQL和过程...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值