将JSON数据文件加载到Oracle 12c中

SQL> host cat c:\temp\json.dat
{
    "glossary": {
        "title": "example glossary",
    "GlossDiv": {
            "title": "S",
      "GlossList": {
                "GlossEntry": {
                    "ID": "SGML",
          "SortAs": "SGML",
          "GlossTerm": "Standard Generalized Markup Language",
          "Acronym": "SGML",
          "Abbrev": "ISO 8879:1986",
          "GlossDef": {
                        "para": "A meta-markup language, used to create markup languages such as DocBook.",
            "GlossSeeAlso": ["GML", "XML"]
                    },
          "GlossSee": "markup"
                }
            }
        }
    }
}

SQL> create table t ( my_json clob, constraint chk check ( my_json is json ));

Table created.

SQL> declare
  2    b bfile := bfilename('TEMP','json.dat');
  3    c clob;
  4  begin
  5    dbms_lob.open(b);
  6    dbms_lob.createtemporary(c,true);
  7
  8    dbms_lob.loadfromfile(c,b,dbms_lob.getlength(b));
  9    insert into t values (c);
 10    commit;
 11    dbms_lob.freetemporary(c);
 12  end;
 13  /

PL/SQL procedure successfully completed.

SQL>
SQL> select * from t;

MY_JSON
--------------------------------------------------------------------------------
{
    "glossary": {
        "title": "example glossary",
    "GlossDiv": {
            "title": "S",
      "GlossList": {
                "GlossEntry": {
                    "ID": "SGML",
          "SortAs": "SGML",
          "GlossTerm": "Standard Generalized Markup Language",
          "Acronym": "SGML",
          "Abbrev": "ISO 8879:1986",
          "GlossDef": {
                        "para": "A meta-markup language, used to create markup l
anguages such as DocBook.",
            "GlossSeeAlso": ["GML", "XML"]
                    },
          "GlossSee": "markup"
                }
            }
        }
    }
}