PL/sql与SQL 2005在语法上的差异 [英] difference in syntax between Oracle PL/sql and SQL 2005

问题描述

我是pl sql的新手.OraclePL/sql和SQL 2005 Server的语法是否有区别?

解决方案

阅读以下内容:

http://stackoverflow.com/questions/290829/differences-between-sql-and- pl-sql [ ^ ]

http://it.toolbox. com/blogs/oracle-guide/what-is-the-the-difference-between-oracle-sql-and-plsql-9602 [ 解决方案

Read the following :

http://stackoverflow.com/questions/290829/differences-between-sql-and-pl-sql[^]

http://it.toolbox.com/blogs/oracle-guide/what-is-the-difference-between-oracle-sql-and-plsql-9602[^]

Definitely, both products provide special features accesible through extensions to SQL. For regular selects, inserts and updates you are not likely to encounter those differences.

Best regards
Espen Harlinn

Sql Server uses T-SQL and Oracle uses PL/SQL.
PL-SQL uses packages which is a concept that does not exist in SQL server.
Actually when you have a piece of code in SQL server for a stored procedure, the chance is rather high that it is not directly portable to oracle and vice versa except perhaps for very simple cases.
So the simple answer to your question is yes, there are a lot of syntax differences between oracle pl/sql and sql server. There might be a standard to define and standarise SQL, but there is no such standard when it comes to programming stored procedures.

这篇关于PL/sql与SQL 2005在语法上的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！