Oracle SQL-Developer：导出“解释计划”图片？
我正在尝试从 Oracle SQL Developer 2.1.0.63 导出解释计划的副本，
我得到的只是一个名为我指定的内容的 html 文件，然后是同一目录中新创建的名为“images”的文件夹，该文件夹是空的。
我对（咳）表格（咳）HTML 输出进行了压缩，发现指定了六张图像，但我认为有 CSS（未指定内联样式，但未导入 CSS）和 Javascript（扩展/收缩区域）我也失踪了。
我尝试在谷歌上搜索最独特的图像名称，但找不到任何其他有关此问题的资源。
网上是否有一个位置可以获取这些图像/CSS/Javascript，或者这是一个错误，并且某个地方有修复程序，或者我只是一个菜鸟？
我使用 SQL Developer 的机器具有完整的管理权限，因此不应该是缺乏创建权限的问题，特别是在我自己的桌面/我的文档中，除非有另一个存储图像的位置。我正在搜索现在我的硬盘，看看我是否可以在任何地方找到它们......
I'm trying to export a copy of the Explain Plan from 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.
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.
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?
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...
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
如果您查看 SQL Developer 目录，会发现有一个文件
oracle.sqldeveloper.worksheet.jar使用 IZArc（或 WinZip 或类似工具）在
oracle/dbtools/worksheet/images下打开它你会找到你需要的。
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.
我使用了打印命令，并打印到 PDF 打印机。这给了我 PDF 中完整的解释计划输出。
I used the print-command, and printed to a PDF-Printer. That gave me exactly the whole explain plan output inside a PDF.
您是否考虑过使用普通的旧 SQL 创建解释计划？
http://download.oracle.com/docs/cd/ B19306_01/server.102/b14211.pdf
Have you considered creating an explain plan using plain old SQL?
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211.pdf
我最近遇到了这个问题，并创建了一个小批处理脚本（需要 sed），将所有必需的图像作为 css 资源直接插入到导出计划 html 文件中。因此，您可以分享您的计划，接收者将看到正常图像，而不是“损坏的图像”图标。
https://anilech.blogspot.com /2016/05/how-to-keep-images-inside-oracle-sql.html
我知道，这是非常及时的回复:)
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.
https://anilech.blogspot.com/2016/05/how-to-keep-images-inside-oracle-sql.html
I know, this is very timely response :)