Toad World® Forums

Add ability to set CLOB to NULL in Popup Editor

It would be nice if there were a button/ability to set a Popup Editor on a CLOB to be NULL.

Currently you can press F7 Clear to perform an EMPTY_CLOB(), but this results in a zero length CLOB which is not the same as a NULL.

It would be helpful to have a NULL button/ability to save the effort of having to create an UPDATE...SET =NULL in a separate Editor window.

Thanks for the idea. We should really just use the update...set=null syntax right from the popup editor after you clear it, so there is no need for a separate button.