Oracle SQL-Developer：导出“解释计划”图像？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2414578/
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
Oracle SQL-Developer: Export "Explain Plan" Images?
提问by glasnt
I'm trying to export a copy of the Explain Plan from Oracle SQL Developer 2.1.0.63
我正在尝试从 Oracle SQL Developer 2.1.0.63 导出解释计划的副本
All I get out is a html file named what I specify, then a newly created folder in the same directory called "images", which is empty.
我得到的只是一个以我指定的名称命名的 html 文件，然后在同一目录中新建了一个名为“images”的文件夹，该文件夹是空的。
I've taken a squizz at the (cough)tabular(cough) HTML output, found there's half a dozen images specified, but I think there's CSS (style not specified inline, CSS not imported though) and Javascript (expand/contract areas) that I'm missing as well.
我对（咳嗽）表格（咳嗽）HTML 输出进行了调查，发现指定了六个图像，但我认为有 CSS（样式未指定内联，CSS 未导入）和 Javascript（扩展/收缩区域）我也失踪了。
I've tried googling the names of the images that are most unique, but I can't find any other resource with this issue.
我试过在谷歌上搜索最独特的图像的名称，但找不到任何其他有关此问题的资源。
Is there a location online I can get these images/CSS/Javascript, OR is this a bug AND there is a fix somewhere OR am I just a noob?
是否有在线位置我可以获取这些图像/CSS/Javascript，或者这是一个错误并且某处有修复程序还是我只是一个菜鸟？
The machine I'm using SQL Developer on has full admin rights, so it shouldn't be an issue of lack of create rights, especially in my own desktop/my documents UNLESS there's another place the images are stored in. I'm searching my HDD now, to see if I can find them anywhere...
我正在使用 SQL Developer 的机器具有完全的管理员权限，所以这不应该是缺乏创建权限的问题，尤其是在我自己的桌面/我的文档中，除非图像存储在另一个地方。我正在搜索我现在的硬盘，看看我是否可以在任何地方找到它们...
回答by Gary Myers
If you look in the SQL Developer directory, there is a file oracle.sqldeveloper.worksheet.jarOpen that with IZArc (or WinZip or some equivalent) and under oracle/dbtools/worksheet/imagesyou'll find the ones you'll need.
如果您在 SQL Developer 目录中查看，有一个oracle.sqldeveloper.worksheet.jar使用 IZArc（或 WinZip 或其他等效工具）打开的文件，oracle/dbtools/worksheet/images您将在下面找到您需要的文件。
回答by Stefan
I used the print-command, and printed to a PDF-Printer. That gave me exactly the whole explain plan output inside a PDF.
我使用了打印命令，并打印到 PDF 打印机。这给了我 PDF 中完整的解释计划输出。
回答by anilech
I've recently hit this issue and created a small batch script (requires sed) to insert all required images directly into export plan html file as css resources. So you can share your plan and receiver will see normal images, not "broken image" icons.
我最近遇到了这个问题并创建了一个小批量脚本（需要 sed）来将所有需要的图像作为 css 资源直接插入到导出计划 html 文件中。所以你可以分享你的计划，接收者会看到正常的图像，而不是“破碎的图像”图标。
https://anilech.blogspot.com/2016/05/how-to-keep-images-inside-oracle-sql.html
https://anilech.blogspot.com/2016/05/how-to-keep-images-inside-oracle-sql.html
I know, this is very timely response :)
我知道，这是非常及时的回应:)
回答by Rene
Have you considered creating an explain plan using plain old SQL?
您是否考虑过使用普通的旧 SQL 创建解释计划？
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211.pdf
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211.pdf
