Can we compare T-SQL & PL/SQL ? , how we define the differences between these , and WHY its different ? end of the day their scenario is Data definition and data manipulation :-S
我们可以比较T-SQL和PL / SQL吗? ,我们如何定义这些之间的差异,为什么它的不同?他们的场景是数据定义和数据操作的一天结束:-S
2 个解决方案
#1
1
They are different because they were written by two different sets of programmers. There is always more than one way to solve a problem. They go beyond the standard SQL because they are looking for something that either isn't in the standard and should have been, is a nice to have feature (that will sell more units) or they want something that will perform faster (performance is critical in Enterprise databases). They are trying to sell their product, so of course they want to make something that is enough different that it will be a selling point.
它们是不同的,因为它们是由两组不同的程序员编写的。解决问题的方法总是不止一种。它们超越了标准的SQL,因为它们正在寻找一些不符合标准且应该已经存在的东西,具有很好的功能(可以销售更多单元)或者它们需要能够更快执行的东西(性能至关重要)在企业数据库中)。他们正试图出售他们的产品,所以当然他们想要做出足够不同的东西,这将是一个卖点。
#2
2
PL/SQL is from Oracle. T-SQL is from Microsoft. Both companies want to implement extras that make things easier for their developers, but since they are outside of the SQL standard they get new names.
PL / SQL来自Oracle。 T-SQL来自微软。两家公司都希望实现额外功能,使开发人员更容易,但由于他们不在SQL标准之内,因此他们获得了新名称。
#1
1
They are different because they were written by two different sets of programmers. There is always more than one way to solve a problem. They go beyond the standard SQL because they are looking for something that either isn't in the standard and should have been, is a nice to have feature (that will sell more units) or they want something that will perform faster (performance is critical in Enterprise databases). They are trying to sell their product, so of course they want to make something that is enough different that it will be a selling point.
它们是不同的,因为它们是由两组不同的程序员编写的。解决问题的方法总是不止一种。它们超越了标准的SQL,因为它们正在寻找一些不符合标准且应该已经存在的东西,具有很好的功能(可以销售更多单元)或者它们需要能够更快执行的东西(性能至关重要)在企业数据库中)。他们正试图出售他们的产品,所以当然他们想要做出足够不同的东西,这将是一个卖点。
#2
2
PL/SQL is from Oracle. T-SQL is from Microsoft. Both companies want to implement extras that make things easier for their developers, but since they are outside of the SQL standard they get new names.
PL / SQL来自Oracle。 T-SQL来自微软。两家公司都希望实现额外功能,使开发人员更容易,但由于他们不在SQL标准之内,因此他们获得了新名称。