declare
js string(4000 byte);
begin
js := '{"Amount":10.1}';
dbms_output.put_line('Territory: AMERICA');
execute immediate 'ALTER SESSION SET NLS_TERRITORY = ''AMERICA''';
dbms_output.put_line('Amount as string: ' || json_value(js, '$.Amount'));
dbms_output.put_line('Amount as number: ' || json_value(js, '$.Amount' returning number));
dbms_output.put_line('Territory: GREECE');
execute immediate 'ALTER SESSION SET NLS_TERRITORY = ''GREECE''';
dbms_output.put_line('Amount as string: ' || json_value(js, '$.Amount'));
dbms_output.put_line('Amount as number: ' || json_value(js, '$.Amount' returning number));
end;