Thursday, March 19, 2015

Oracle PL/JSON - Installation

Had good great experience with PL/JSON for a year; Here the steps I followed to install PL/JSON into my oracle 12C DB.

Installation


  1. Got PL/JSON from GitHub using git clone
  2. Opened 'install.sql' file in SQLDeveloper and selected the DB connection to run the release
  3. Used 'Run Script' option from SQLDeveloper. 
  4. Watched 'Script Output' for no errors


Test


  1. Opened another 'SQL WorkSheet' and copy and pasted the Example-1 and executed the Script. 
  2. In Script output, verified the JSON data print.


No comments:

Post a Comment