How to grant SYSDBA privilege to an user?

grant connect ,resource,DBA to USER

How to resove PLS-00201: identifier 'JSON' must be declared error in oracle?

1. Need to install the PL/JSON package
2. GRANT EXECUTE ON JSON TO <user>;

How to parse JSON in oracle?

 In 11g, we need to install the utilities for  JSON
1.
APEX_JSON

https://docs.oracle.com/cd/E59726_01/doc.50/e39149/apex_json.htm#AEAPI29635

2.

PL/JSON

https://sourceforge.net/p/pljson/wiki/Home/

3. upgrade to 12c

After the installation we can use the JSON, JSON_LIST type we can parse the JSON files...

HOW TO GRANT THE JSON OBJECT TYPE TO USER IN ORACLE?

SQL> GRANT EXECUTE ON JSON TO MURUGA;
Grant succeeded


SQL> GRANT EXECUTE ON JSON_LIST TO MURUGA;
Grant succeeded

SQL> GRANT EXECUTE ON JSON_VALUE TO MURUGA;
Grant succeeded


SQL> GRANT EXECUTE ON JSON_VALUE_ARRAY TO MURUGA;
Grant succeeded

HOW TO LIST THE JSON OBJECT TYPES IN ORACLE?


SQL> SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TYPE' AND OBJECT_NAME LIKE '%JSON%'
  2  ;
OBJECT_NAME                                                                      SUBOBJECT_NAME                  OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE         CREATED     LAST_DDL_TIME TIMESTAMP           STATUS  TEMPORARY GENERATED SECONDARY  NAMESPACE EDITION_NAME
-------------------------------------------------------------------------------- ------------------------------ ---------- -------------- ------------------- ----------- ------------- ------------------- ------- --------- --------- --------- ---------- ------------------------------
JSON                                                                                                                443607                TYPE                5/19/2017 9 5/19/2017 9:2 2017-05-19:09:23:57 VALID   N         N         N                  1
JSON_LIST                                                                                                           443606                TYPE                5/19/2017 9 5/19/2017 9:2 2017-05-19:09:23:57 VALID   N         N         N                  1
JSON_TAB                                                                                                            439925                TYPE                5/18/2017 4 5/18/2017 4:3 2017-05-18:16:33:19 VALID   N         N         N                  1
JSON_VALUE                                                                                                          443604                TYPE                5/19/2017 9 5/19/2017 9:2 2017-05-19:09:23:56 VALID   N         N         N                  1
JSON_VALUE_ARRAY                                                                                                    443605                TYPE                5/19/2017 9 5/19/2017 9:2 2017-05-19:09:23:57 VALID   N         N         N                  1