CODEWITHSUNDEEP
oracle-database
Drupal8ForTheWin
Drupal8ForTheWin

Reputation: 145

How to show widememo column?

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?

Thx in advice

Example

Upvotes: 2

Views: 25728

Answers (2)

Rahul Malireddy
Rahul Malireddy

Reputation: 31

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

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

Upvotes: 0

Alex Poole
Alex Poole

Reputation: 191415

The (WIDEMEMO) label is hiding LONG or CLOB data (or potentially a field defined a VARCHAR2 with a high maximum size - some clients do that but I don't think Toad does).

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:

View => Toad Options => Data Grids => Data => [x] Preview CLOB and LONG data

Upvotes: 10

Related Questions