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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
70 views