oracle 生成 json文件,oracle - PLSQL导入JSON并导出为JSON文件 - 堆栈内存溢出

用于处理json的设置：

create table json_from_file (id number, data clob, constraint chk_data_is_json check (data is json));

insert into json_from_file (id, data)

values ( 1, '{

"id" : 1,

"created_at" : "Tue Oct 22 16:08:59 +0000 2013",

"text" : "RT @Piratenpartei: Der @humanErr zur EU Datenschutzverordnung #EUDataP : “Starker EU-Datenschutz darf nicht scheitern” ",

"lang" : "de",

"place" : null,

"retweet_count" : 10,

"user" : {

"created_at" : "Mon Jun 03 12:37:14 +0000 2013",

"description" : "Der Bezirksverband Tübingen im Landesverband Baden-Württemberg",

"followers_count" : 122,

"id" : 1479629599,

"lang" : "de",

"name" : "