Oracle存储过程与SQL Server存储过程相同 [英] Oracle Stored Procedures VERSUS SQL Server Stored Procedures
问题描述
我想知道SQL Server 2000存储
程序和oracle存储过程之间的区别？他们有不同的
语法吗？这个概念应该与存储过程在数据库服务器中执行的性能更好相同吗？
请建议Oracle存储过程的良好参考。
谢谢!!
I want to know the differences between SQL Server 2000 stored
procedures and oracle stored procedures? Do they have different
syntax? The concept should be the same that the stored procedures
execute in the database server with better performance?
Please advise good references for Oracle stored procedures also.
thanks!!
推荐答案
< jr ********@hotmail.com>在消息中写道
news：11 ******************** @ g43g2000cwa.googlegrou ps.com ...
<jr********@hotmail.com> wrote in message
news:11********************@g43g2000cwa.googlegrou ps.com...
我想知道SQL Server 2000存储的程序和oracle存储过程之间的区别？他们有不同的语法吗？这个概念应该与存储过程在数据库服务器中执行具有更好性能的相同？
请同时为Oracle存储过程提供良好的参考。
谢谢!!
I want to know the differences between SQL Server 2000 stored
procedures and oracle stored procedures? Do they have different
syntax? The concept should be the same that the stored procedures
execute in the database server with better performance?
Please advise good references for Oracle stored procedures also.
thanks!!
SQL Server存储过程使用transact sql并在SQL Server上运行
Oracle存储过程使用pl / sql（在ADA上建模）并在Oracle上运行。$ / $
Oracle！= SQL Server
他们使用两种非常不同的并发模型，语法完全是
不一样。
（例如你不需要像在SQL Server中那样在Oracle中创建临时表）
otn.oracle.com并查看文档。
Jim
SQL Server Stored procedures use transact sql and run on SQL Server
Oracle Stored Procedures use pl/sql (modeled on ADA) and run on Oracle.
Oracle!=SQL Server
They use two very different concurrent models and the syntax is totally
different.
(eg you don''t need to create temp tables in Oracle like in SQL Server)
otn.oracle.com and look under documentation.
Jim
2005年7月7日星期四20:38:52 -0700，jrefactors写道：
On Thu, 07 Jul 2005 20:38:52 -0700, jrefactors wrote:
我想知道SQL Server 2000存储的程序和oracle存储过程之间的区别？他们有不同的语法吗？
I want to know the differences between SQL Server 2000 stored
procedures and oracle stored procedures? Do they have different
syntax?
不，你只需要获得微软版的PL / SQL。
-
http://www.mgogala.com
No, you just have to obtain Microsoft version of PL/SQL.
--
http://www.mgogala.com
2005年7月7日星期四20:38:52 -0700，jrefactors通过写作感兴趣：
On Thu, 07 Jul 2005 20:38:52 -0700, jrefactors interested us by writing:
它们是完全不同的语言。
Oracle PL / SQL使用强大的Ada语言作为模板。
不确定Sybase使用的是什么模板 - 似乎是Pascal
和Basic的混合。这也是非常合理的。 IIRC，当他们将核心转换为SQL Server时，微软已经基本上不会扩展基本的b
- 很多不错的附加组件。
更重要的是，由于数据库内部的差异，例如锁定策略，你需要接近代码的方式是
显着不同。例如，在SQL Server中，使用
动态创建临时表以保存中间结果是合理的，而在
ORacle中，您使用预定义的全局临时表。在甲骨文中，读者不会因为作者而不能阻止读者到目前为止不那么明确的锁定
一般发生在Oracle中。在Oracle中，杀死你的b / b $ b可扩展性的最快方法是为每个客户端动态构建你的SQL语句 -
绑定变量非常非常有用。 />
请建议Oracle存储过程的良好参考资料。
I want to know the differences between SQL Server 2000 stored
procedures and oracle stored procedures? Do they have different
syntax?
They are completely different languages.
Oracle PL/SQL uses the robust Ada language as it''s template.
Not sure what Sybase used as it''s template - seems like a mix of Pascal
and Basic. Very reasonable in it''s own way as well. IIRC, Microsoft has
not extended the basic too much when they turned the core into SQL Server
- lots of nice add-ons though.
More to the point, because of the differences in database internals, such
as locking strategies, the way you need to approach your code is
significantly different. For example, in SQL Server it''s reasonable to
create temp tables on the fly to hold intermediate results, whereas in
ORacle you use a predefined global temp table. In Oracle, readers don''t
block writers and writers don''t block readers so far less explicit locking
occurs in Oracle in general. And in Oracle, the fastest way to kill your
scalability is to build your SQL statement on the fly for each client -
bind variables are very, very useful.
Please advise good references for Oracle stored procedures also.
所有Oracle docco免费在线， http://docs.oracle.com ...
推荐阅读应用开发人员是（按顺序）：
Oracle概念手册
Oracle应用程序开发人员指南 - 基础知识
Oracle SQL参考
Oracle PL / SQL用户指南和参考
Oracle提供的PL / SQL包和类型参考
请注意Oracle耗材在数据库中添加了大量的东西，
最多，无需额外费用。此类别中的一些示例包括：
消息排队;文本索引和搜索; doc索引和搜索;
多媒体存储和检索;工作流程; OLAP; XML。 （是的，许多人也会在SQL Server中出现
。）
为避免重复提供的内容，我建议您选择
关于API和示例的剩余手册和指南。
以下书籍，IMO，在您的图书馆中是强制性的：
O''Reilly" ;掌握Oracle SQL"
- 有很多不需要PL / SQL
APress掌握Oracle PL / SQL
- 圣经！
Oracle Press有效的Oracle设计
- 必须阅读，如果你关心性能
- 去一个很长的方式来解释代码风格的差异
玩得开心
-
Hans Forbrich
加拿大范围内的Oracle培训和咨询
mailto：Fuzzy.GreyBeard_at_gmail.com
***我不再协助发布最新帖子的新闻组***
All Oracle docco is online, free of charge, at http://docs.oracle.com ...
recommended reading for an app developer is (in order):
Oracle Concepts manual
Oracle Application Developer''s Guide - Fundamentals
Oracle SQL Reference
Oracle PL/SQL User''s Guide and Reference
Oracle Supplied PL/SQL Packages and Types Reference
Note that Oracle supplies a whole pile of added things in the database,
most at no added charge. Some examples in this category include:
message queueing; text indexing and search; doc indexing and search;
multimedia storage and retrieval; workflow; OLAP; XML. (Yes many also
occur in SQL Server.)
To avoid duplicating what is provided, I recommend selecting from the
remaining manuals and guides for API and examples.
The following books are, IMO, mandatory in your library:
O''Reilly "Mastering Oracle SQL"
- there''s a lot that doesn''t need PL/SQL
APress "Mastering Oracle PL/SQL"
- bible!
Oracle Press "Effective Oracle by Design"
- a MUST read if you care about performance
- goes a LONG way to explaining the differences in code style
Have fun
--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***
这篇关于Oracle存储过程与SQL Server存储过程相同的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
