oracle 如何显示widememo列？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/25358364/
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
How to show widememo column?
提问by Drupal8ForTheWin
I'm searching some informations in my DB of my ETL(GENIO) and I'm kinda lost. I would like to know if they're a way to remplace/show the value of a column with "(WIDEMEMO)" ? And also what is-it?
我正在我的 ETL(GENIO) 的数据库中搜索一些信息，但我有点迷茫。我想知道它们是否是一种用 "(WIDEMEMO)" 替换/显示列值的方法？还有什么是——它？
Thx in advice
谢谢你的建议
回答by Alex Poole
The (WIDEMEMO)label is hiding LONGor CLOBdata (or potentially a field defined a VARCHAR2with a high maximum size - some clients do that but I don't think Toad does).
该(WIDEMEMO)标签隐藏LONG或CLOB数据（或潜在的字段定义的VARCHAR2高最大尺寸-有些客户这样做，但我不认为蟾蜍一样）。
You can click on the a hidden value to see the actual data within. And as noted here, you can turn on the preview from Toad's menus:
您可以单击隐藏值以查看其中的实际数据。正如此处所述，您可以从 Toad 的菜单中打开预览：
View => Toad Options => Data Grids => Data => [x] Preview CLOB and LONG data
查看 => Toad 选项 => 数据网格 => 数据 => [x] 预览 CLOB 和 LONG 数据
回答by Rahul Malireddy
Try to connect from putty and see. It will give the invisible column and the underlying columns on which it has been built.
尝试从腻子连接并查看。它将给出不可见的列和它所建立的基础列。
I had a similar problem when Toad was showing WIDEMEMO, but when i tried from Putty it showed me the underlying columns as show below
当 Toad 显示 WIDEMEMO 时，我遇到了类似的问题，但是当我从 Putty 尝试时，它向我显示了如下所示的底层列
eg:
例如：
SQL> select column_name, data_default, hidden_column from dba_tab_cols where column_name='SYS_STSV3T25IIMSBK3RLDOCESQVID';
COLUMN_NAME DATA_DEFAULT HID
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---
SYS_STSV3T25IIMSBK3RLDOCESQVID SYS_OP_COMBINED_HASH("KT_NUM","SRAM_ATS_NUM") YES
