I am working under oracle 12C 12.2.0.1.0, I implemented a pl / sql script which allows to load data from a json file into a table. The problem is that I cannot mine the data because it appears in Chinese or Japanese language after inserting into the table.
I have done a lot of research on the internet but could not solve the problem, even though the work is very urgent.
Please help me.
Below, a screenshot of the image showing the data from the json file inserted into the "DATA" field of the table.
select * from nls_database_parameters
where parameter in ( 'NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET');
NLS_CHARACTERSET = AL32UTF8
NLS_NCHAR_CHARACTERSET = AL16UTF16