如何在 Oracle 表单 fmb 文件中搜索 PL/SQL 代码?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/16544650/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-19 01:39:54  来源:igfitidea点击:

How do you search for PL/SQL code in Oracle forms fmb files?

oracleplsqloracleforms

提问by dhinkle

How do you find code if you don't know which Form it's in. If you know the form you can search pl sql but what if you don't know form?

如果您不知道它在哪个表单中,您如何找到代码。如果您知道表单,您可以搜索 pl sql 但如果您不知道表单怎么办?

For example I know the name of a field that is used in some code I want to see but don't know where code is at.

例如,我知道在我想查看的某些代码中使用的字段的名称,但不知道代码在哪里。

回答by Jeffrey Kemp

I highly recommend FormsTool - it understands the FMB, RDF and PLL formats natively, you can optionally search in object attributes as well as code. It shows the code search results with context (i.e. a few lines before and after).

我强烈推荐 FormsTool - 它本机理解 FMB、RDF 和 PLL 格式,您可以选择搜索对象属性和代码。它显示了带有上下文的代码搜索结果(即前后几行)。

http://www.orcl-toolbox.com/formstool/

http://www.orcl-toolbox.com/formstool/

回答by nightfox79

I always use total commander for this, it is easy. You can find text in fmb's.

为此我总是使用总指挥官,这很容易。您可以在 fmb 中找到文本。

You can also open all your fmb's in one forms builder and then search over all of them. This is ofcourse no option if you got 1000 fmb's or so.

您还可以在一个表单构建器中打开所有 fmb,然后搜索所有这些。如果您有 1000 个 fmb 左右,这当然是没有选择的。

Third possibility is to convert your fmb's to xml and search in the xml files. http://docs.oracle.com/cd/E14373_01/migrate.32/e13368/appmgr_forms.htm#CHDCFFIC

第三种可能性是将您的 fmb 转换为 xml 并在 xml 文件中搜索。 http://docs.oracle.com/cd/E14373_01/migrate.32/e13368/appmgr_forms.htm#CHDCFFIC

回答by DCookie

I just use grep. There are versions for Windows, too.

我只使用grep。也有适用于 Windows 的版本

回答by DJPeter

In addition to FormsTool (that are not free) you can use whatever tool that allows you to do text searches inside files. Myself I'm using PSPad freeware editor and its 'Search / Replace in Files...) function.

除了 FormsTool(不是免费的)之外,您还可以使用任何允许您在文件中进行文本搜索的工具。我自己我正在使用 PSPad 免费软件编辑器及其“在文件中搜索/替换...)功能。