所需信息:有哪些值得关注的最佳 PL/SQL 博客?
我是 PL/SQL
的新手,我想了解 PL/SQL
的不同方面,所以我有几个问题,
- 开发人员应该了解哪些概念 知道称自己为 PL/SQL 开发商?
pl/sql
开发人员应该使用哪些最佳博客 跟随 ?
注意:Google 搜索并未提供如此丰富的结果。
I am new to PL/SQL
and I want to understand different aspects of PL/SQL
so I have couple of questions,
- What concepts should a developer
know to call himself as an PL/SQL
Developer ? - What are the best blogs available which
pl/sql
developer should
follow ?
Note: Google Search didn't gave that fruitful results.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(4)
每个 PL/SQL 开发人员都应该阅读 Steven Feuerstein 撰写的 Oracle PL/SQL 编程,这是对该语言结构的精彩介绍以及它与大多数语言的数据库特定性质有何不同。
除了对 Oracle 数据库的良好应用知识之外,需要理解 PL/SQL 的一些关键概念包括(但不限于):
对于博客,请查看 Steven Feuerstein 的 PL/SQL 博客。
http://toadworld.com/Community/ExpertsBlog/tabid/67 /BlogID/13/Default.aspx
他的网站上还有更多资源。看看 PL/SQL 挑战!
http://www.stevenfeuerstein.com
Every PL/SQL developer should read Oracle PL/SQL Programming by Steven Feuerstein as an excellent introduction to the structure of the language and how it differs from most languages by its database-specific nature.
In addition to a good working knowledge of the Oracle Database, some key concepts to understand in PL/SQL include (but are not limited to):
For blogs, take a look at Steven Feuerstein's PL/SQL Blog.
http://toadworld.com/Community/ExpertsBlog/tabid/67/BlogID/13/Default.aspx
He's got lots more resources on his site as well. Take a look at the PL/SQL challenge!
http://www.stevenfeuerstein.com
我对已经说过的内容没有太多补充,除此之外:
问候,
抢。
I don't have much too add to what has already been said, other then:
Regards,
Rob.
每个 PL/SQL 开发人员都应该参加 PL/SQL Challenge(又是 Steven Feurstein)网站:http://www.plsqlchallenge.com /
这是提高 PL/SQL 技能或学习这种编程语言的好方法。
Every PL/SQL developer should participate in PL/SQL Challenge (Steven Feurstein again) site: http://www.plsqlchallenge.com/
It`s a good way to improve your PL/SQL skills or learn this programming language.
1:了解 PL/SQL 最重要的一点是为什么您不想成为 PL/SQL 开发人员。
为了充分利用数据库,您需要使用集合的声明式编程,也称为 SQL。 PL/SQL 是行过程式编程。如果您只使用 SQL,您的代码会更简单,并且速度通常会快一个数量级。
您最好先花时间学习 Oracle 和 SQL 概念,然后再学习 PL/SQL。作为一名恰好编写一些 PL/SQL 的 Oracle 开发人员,您可能会过得更好。
2:几乎每个优秀的 Oracle 博客都是由 OakTable。
但是您不会在那里找到很多 PL/SQL,因为 PL/SQL 不是很有趣。我并不是想抱怨 PL/SQL,我认为它是一种很好的语言,但它被过度使用了。 90% 的 PL/SQL 代码可能应该用 SQL 或 Java/C#/etc 重写。
但是...在开始查看博客或 Google 搜索之前,您绝对需要熟悉 Oracle 文档库中的几本书。
没有人使用的东西,但也有
里面有一些非常重要的东西)
您至少需要熟悉这些书的结构,尤其是 SQL 和 PL/SQL 参考资料,这样您以后就可以查找内容。尽管它们庞大而复杂,但也极其彻底和准确。仅语法图就可以节省您大量的谷歌搜索时间。
1: The most important thing to understand about PL/SQL is why you don't want to be a PL/SQL Developer.
To get the most out of your database you need to use declarative programming with sets, also known as SQL. PL/SQL is procedural programming with rows. If you only use SQL your code will be simpler and usually about an order of magnitude faster.
Your time is much better spent learning about Oracle and SQL concepts first, and then PL/SQL. You'll probably be better off as an Oracle Developer who just happens to write some PL/SQL.
2: Almost every good Oracle blog is by someone who is a member of the OakTable.
But you won't find a lot of PL/SQL there because PL/SQL is not very interesting. I'm not trying to rant about PL/SQL, I think it's a fine language, but it's massively over-used. 90% of all PL/SQL code should probably be re-written in either SQL or Java/C#/etc.
BUT... before you start looking at blogs or Googling you absolutely need to become familiar with a few books from the Oracle documentation library.
stuff nobody uses, but there's also
some really important stuff in there)
You need to at least be familiar with the structure of those books, especially the SQL and PL/SQL reference, so you can look up things later. Although they are large and complicated they are also extremely thorough and accurate. The syntax diagrams alone will save you many hours of Googling.