SWKB.NET

The Software Knowledge Base

  • Increase font size
  • Default font size
  • Decrease font size
Home Oracle DB Oracle DB: How To Examples Oracle DB: Convert LONG to VARCHAR on the fly

Oracle DB: Convert LONG to VARCHAR on the fly

E-mail Print PDF

Use the following code in order to search in a LONG field:

SELECT * FROM sys.trigger$ /* table, not view */ 
WHERE sys.dbms_metadata_util.long2varchar( 4000 ,'SYS.TRIGGER$','ACTION#', ROWID) LIKE '%rvtrig_upd%';

Note, that for the statement above, you can not use ALL_TRIGGERS or DBA_TRIGGERS, because this function does not work with views (which do not have rowid)

Last Updated on Tuesday, 24 July 2012 14:54  

mod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_counter
mod_vvisit_counterToday246
mod_vvisit_counterYesterday202
mod_vvisit_counterThis week1523
mod_vvisit_counterLast week1708
mod_vvisit_counterThis month8479
mod_vvisit_counterLast month7264

We have: 1 guests online
Your IP: 54.80.184.8
 , 
Today: May 27, 2016

Empasi - empowering youth in Eastern Europe

  

Latest Articles


Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_latestnews/helper.php on line 109

Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_latestnews/helper.php on line 109

Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_latestnews/helper.php on line 109

Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_latestnews/helper.php on line 109

Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_latestnews/helper.php on line 109

Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_latestnews/helper.php on line 109

Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_latestnews/helper.php on line 109

Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_latestnews/helper.php on line 109

Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_latestnews/helper.php on line 109

Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_latestnews/helper.php on line 109

Popular Articles


Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_mostread/helper.php on line 79

Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_mostread/helper.php on line 79

Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_mostread/helper.php on line 79

Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_mostread/helper.php on line 79

Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_mostread/helper.php on line 79

Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_mostread/helper.php on line 79

Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_mostread/helper.php on line 79

Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_mostread/helper.php on line 79

Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_mostread/helper.php on line 79

Warning: Creating default object from empty value in /home3/vagos/public_html/swkb.net/modules/mod_mostread/helper.php on line 79