Can we add the ablity to view CLOB/BLOB/JSONs in formatted fashion (using pretty function) in the data grid as an enhancement?
Toad 15.1 has some support for this.
It's not possible in the Editor at this time because we have no way of distinguishing the JSON datatype from BLOB without a query to DBA_TAB_COLUMNS. Once we are able to distinguish JSON from BLOB with OCI "prepare" calls, then we'll be able to handle this in the Editor too (similar to what we do with XMLTYPE )
But in the schema browser, we query dba_tab_columns before the query for the data tab is constructed, so we can build the SQL properly there. See Options -> Schema Browser -> Data Tab -> Cast JSON columns
Thanks John. I downloaded the new version and tried. Did not help me because my Oracle is 19c.
We do have a IS_JSON constraints on the blobs. It may help if could make it work with IS_JSON constraint (which is same as JSON type in 21c).
Secondly, you don't have to to see dba_tab_columns to apply the pretty functions. You can let the user click a third option hex/txt/Json pretty (may be xml could be fourth) for all blobs/clobs in the BLOB viewer. Obviously, if it is not a well formed json/xml .. they will see some kind of error.
Thanks
Secondly, you don't have to to see dba_tab_columns to apply the pretty functions. You can let the user click a third option hex/txt/Json pretty
Ok, yes, it sounds like we were talking about different things. I was talking about the 21c JSON datatype. That can be formatted automatically by Oracle (after Toad writes the query to do that).
Sounds like you just want to format data that happens to be JSON. I'll investigate that.
1 Like