团队中用于在Oracle中使用存储过程的工具? [英] Tools to work with stored procedures in Oracle, in a team?

问题描述

团队使用什么工具开发Oracle存储过程:

What tools do you use to develop Oracle stored procedures, in a team :

• 要自动锁定"您正在使用的当前过程，因此团队中没有其他人可以对其进行更改，直到您完成操作为止.
• 要自动将您在Oracle数据库中的存储过程中所做的更改发送到Subversion，CVS，...存储库

谢谢！

推荐答案

我不确定原始海报是否仍在监视此问题，但我还是会提这个问题.

I'm not sure if the original poster is still monitoring this, but I'll ask the question anyways.

原始帖子要求能够:

自动锁定"当前 您正在使用的过程，所以 团队中没有其他人可以做到 直到完成为止.

To automatically "lock" the current procedure you are working with, so nobody else in the team can make changes to it until you are finished.

这里的问题也许是开发范例之一，而不是产品无法锁定"存储的proc的问题.每当我听到我想锁定它，让其他人都不能更改它"时，我立即感觉到人们共享一个模式，每个人都在同一个空间中发展.

Perhaps the problem here is one of development paradigm more than the inability of a product to "lock" the stored proc. Whenever I hear "I want to lock this so noone else changes it" I immediately get the feeling that people are sharing a schema and everyone is developing in the same space.

如果是这种情况，为什么不简单地让每个人都有自己的架构以及数据模型的副本?我是说认真的人，创建另一个架构不会花费"任何东西.这样，每个开发人员都可以进行更改，直到脸色发青，而不会影响其他任何人.

If this is the case, why not simply let everyone have their own schema with a copy of the data model? I mean seriously folks, it doesn't "cost" anything to create another schema. That way, each developer can make changes until they're blue in the face without affecting anyone else.

我过去(在小型团队中)使用的另一种技巧是，由于大小原因，让每个开发人员都无法拥有自己的数据副本时，要拥有一个包含所有表和代码的主架构其中，公共同义词指向所有内容.然后，如果开发人员想要处理存储的proc，则只需在 his 模式中创建它即可.这样，Oracle名称解析将查找第一个而不是查找主模式中的副本，从而使他们能够测试其代码而不影响其他任何人.这确实有其缺点，但这是一个非常具体的案例，我们可以与它们一起生活.我绝对不会在生产中实现这样的事情.

Another trick I've used in the past (on small teams) when it wasn't feasible to let every developer have their own copy of the data because of size, was to have a master schema with all the tables and code in it, with public synonyms pointing to it all. Then, if the developer wants to work on a stored proc, he simply creates it in his schema. That way Oracle name resolution finds that one first instead of the copy in the master schema, allowing them to test their code without affecting anyone else. This does have it's drawbacks, but this was a very specific case where we could live with them. I would NEVER implement something like this in production obviously.

第二项要求:

要自动发送更改，您 在存储过程中 Oracle数据库，Subversion，CVS， ...存储库

To automatically send the changes you make in the stored procedure, in an Oracle database, to a Subversion, CVS, ... repository

我很惊讶地发现那里的工具足够聪明，可以做到这一点(也许是一个机会:).它必须连接到您的数据库，查询数据字典(USER_SOURCE)并提取关联的文本.对于几乎都是基于文件的源代码控制系统来说，这是一个很高的要求.

I'd be surprised to find tools out there smart enough to do this (perhaps an opportunity :). It would have to connect to your db, query the data dictionary (USER_SOURCE) and pull out the associated text. A tall order for source control systems where are almost universally file based.

这篇关于团队中用于在Oracle中使用存储过程的工具?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！