oracle SQL Developer 如何将存储过程导出到单独的文件中？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/24963215/
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
SQL Developer How to export store procedures into separate files?
提问by neo
I am using Oracle SQL Developer 3.2 and I have about 100 stored procedures/functions that I'd like to export them into separate individual files. Here's what I'd like to achieve:
我正在使用 Oracle SQL Developer 3.2 并且我有大约 100 个存储过程/函数，我想将它们导出到单独的单个文件中。这是我想要实现的目标：
- Each file name should be the same as the stored procedure/function name.
- The file content is just the content of the stored procedure/function, as if I open the stored procedure, copy and paste into a text file and save.
- 每个文件名应与存储过程/函数名相同。
- 文件内容只是存储过程/函数的内容，就像我打开存储过程，复制粘贴到一个文本文件中并保存。
Any one knows how to do it? Thanks.
有谁知道怎么做？谢谢。
回答by Sathiya Kumar
As a1ex07stated in his comment. You can achieve that. Go Tools -> Database Export -> Select the file where you want to create stored procedure/function and select the connection name -> Types to Export -> Specify Object -> Specify Data -> Finish
正如a1ex07在他的评论中所说。你可以做到这一点。转到工具 -> 数据库导出 -> 选择要创建存储过程/函数的文件并选择连接名称 -> 要导出的类型 -> 指定对象 -> 指定数据 -> 完成
