所需信息:有哪些值得关注的最佳 PL/SQL 博客?

发布于 2024-10-28 00:46:11 字数 228 浏览 2 评论 0原文

我是 PL/SQL 的新手,我想了解 PL/SQL 的不同方面,所以我有几个问题,

  1. 开发人员应该了解哪些概念 知道称自己为 PL/SQL 开发商?
  2. 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,

  1. What concepts should a developer
    know to call himself as an PL/SQL
    Developer ?
  2. What are the best blogs available which pl/sql developer should
    follow ?

Note: Google Search didn't gave that fruitful results.

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(4

長街聽風 2024-11-04 00:46:11

每个 PL/SQL 开发人员都应该阅读 Steven Feuerstein 撰写的 Oracle PL/SQL 编程,这是对该语言结构的精彩介绍以及它与大多数语言的数据库特定性质有何不同。

除了对 Oracle 数据库的良好应用知识之外,需要理解 PL/SQL 的一些关键概念包括(但不限于):

  • 执行环境,位于数据库“内部”
  • BEGIN/END 块结构
  • 包、过程、函数、触发器以及匿名块
  • Cursors &迭代行处理 vs 批量行处理
  • 异常处理
  • 动态 SQL 和 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):

  • The execution environment, being "inside" the database
  • The BEGIN/END block structure
  • Packages, procedures, functions, triggers, as well as anonymous blocks
  • Cursors & Iterative row processing vs Bulk row processing
  • Exception handling
  • Dynamic SQL & Execute Immediate
  • Collections & Records
  • Database Transaction Management

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

冷了相思 2024-11-04 00:46:11

我对已经说过的内容没有太多补充,除此之外:

  • 在开始使用 PL/SQL 之前,首先了解数据库和 SQL,
  • 另一个对于 PL/SQL 开发人员来说必不可少的网站 - 而且还没有尚未提及 - 是 http://www.oracle-developer.net/:每个功能都很棒的文章和版本。

问候,
抢。

I don't have much too add to what has already been said, other then:

  • first learn about the database and about SQL, before you start with PL/SQL
  • another site that is indispensable for PL/SQL developers - and that hasn't been mentioned yet - is http://www.oracle-developer.net/: excellent articles per feature and version.

Regards,
Rob.

怎言笑 2024-11-04 00:46:11

每个 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.

ゞ记忆︶ㄣ 2024-11-04 00:46:11

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.

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.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文