Search This Blog

Sunday, September 8, 2019

Json to text Parsing with List ( [ ] ) in Oracle PL/SQL

DECLARE 
    j apex_json.t_values; 
BEGIN 
    apex_json.parse(j, '{ "items": [ 1, 2, { "foo": "qaium" } ] }'); 
  
        dbms_output.put_line('found items[3].foo--'||apex_json.get_varchar2(p_path => 'items[%d].foo', p0 => 3, p_values => j)); 
   
END;

No comments:

Post a Comment

Java to Oracle database Connection Using JDBC

Oracle database. // Java Program to Establish Connection  // in JDBC with Oracle Database // Importing database import java.sql.*; // Import...