While JSON values from varchar columns copy and paste as expected, copying a 23ai json datatype column results in
"[object Object]".
One has to open single record view, click on the three dots and copy / paste from the preview pane.
@thatjeffsmith-oracle : Would be nice, if we can copy/paste json content directly from json cols
-- works in 23ai only
select 1 as json_id, json('{"a":1,"b":2}') as json_data;
-- Ctrl-C Ctrl-V from query result Tab:
[object Object]
--# Single Record View Copy / Paste
[object Object]
-- Single Record View threedots preview:
{
"a": 1,
"b": 2
}
