In PL/SQL Developer v7.1.x, is there way way to ignore large data types in queries or the "Query Data" feature. For example: If you right click on table FOO
, and select "Query Data" this will execute a SELECT * FROM FOO
. If that table contains BLOB
data the query will take a while to complete and temporarily lock up the application. This is especially problematic when querying remote databases (for obvious reasons).
在PL / SQL Developer v7.1.x中,有没有办法忽略查询中的大数据类型或“查询数据”功能。例如:如果您右键单击表FOO,并选择“查询数据”,这将执行SELECT * FROM FOO。如果该表包含BLOB数据,则查询将花费一些时间来完成并暂时锁定应用程序。查询远程数据库时(特别是显而易见的原因),这尤其成问题。
I would like a way to tell PL/SQL Developer not to retrieve large data by default. I know there is a way to limit the ResultSet size but this doesn't do what I am looking for.
我想告诉PL / SQL Developer默认情况下不要检索大数据。我知道有一种方法可以限制ResultSet的大小,但这并不能解决我想要的问题。
I could just select each column I wanted ignoring certain ones but then I couldn't use the "Query Data" feature.
我可以选择我想要忽略某些列但我不能使用“查询数据”功能的每一列。
Thanks.
3 个解决方案
#1
No, the Query Data feature does one thing and one thing only - queries all the data.
不,查询数据功能只做一件事,只做一件事 - 查询所有数据。
What you might find useful is that you can drag the name of a table or view from the Browser into a SQL Window, choose "Select" from the menu that pops up, and it will generate a SELECT statement on the table with all the column names included - but does not execute the query straight away. You can then edit it however you like (e.g. comment out the LOB columns) before you run it.
您可能会发现有用的是您可以将表或视图的名称从浏览器拖到SQL窗口中,从弹出的菜单中选择“选择”,它将在表上生成一个包含所有列的SELECT语句包含的名称 - 但不会立即执行查询。然后,您可以在运行之前编辑它(例如注释掉LOB列)。
#2
I know that Toad
has something like that built in, but I'm not aware of a PL/SQL Developer option that disables BLOBS.
我知道Toad有类似内置的东西,但我不知道PL / SQL Developer选项会禁用BLOBS。
The option you are left with, for now, is to simply select all the columns individually and truncate the blob.
您现在剩下的选项是单独选择所有列并截断blob。
ie:
select foo, bar, trunc(baz,100) from foo where ...
从foo中选择foo,bar,trunc(baz,100)......
#3
Create a View that doesn't contain the blob column or whatever columns you don't routinely want to look at.
创建一个不包含blob列的视图或您不经常要查看的任何列。
#1
No, the Query Data feature does one thing and one thing only - queries all the data.
不,查询数据功能只做一件事,只做一件事 - 查询所有数据。
What you might find useful is that you can drag the name of a table or view from the Browser into a SQL Window, choose "Select" from the menu that pops up, and it will generate a SELECT statement on the table with all the column names included - but does not execute the query straight away. You can then edit it however you like (e.g. comment out the LOB columns) before you run it.
您可能会发现有用的是您可以将表或视图的名称从浏览器拖到SQL窗口中,从弹出的菜单中选择“选择”,它将在表上生成一个包含所有列的SELECT语句包含的名称 - 但不会立即执行查询。然后,您可以在运行之前编辑它(例如注释掉LOB列)。
#2
I know that Toad
has something like that built in, but I'm not aware of a PL/SQL Developer option that disables BLOBS.
我知道Toad有类似内置的东西,但我不知道PL / SQL Developer选项会禁用BLOBS。
The option you are left with, for now, is to simply select all the columns individually and truncate the blob.
您现在剩下的选项是单独选择所有列并截断blob。
ie:
select foo, bar, trunc(baz,100) from foo where ...
从foo中选择foo,bar,trunc(baz,100)......
#3
Create a View that doesn't contain the blob column or whatever columns you don't routinely want to look at.
创建一个不包含blob列的视图或您不经常要查看的任何列。