Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bug: 23ai JSON columns copy & paste as [object Object]

Robbie DatabeeJan 26 2025

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 
}

Comments
Post Details
Added on Jan 26 2025
1 comment
436 views