How to work with JSON on Oracle Database 11g?

Oracle Database 11g

There are "json, json_value, and json_list" types for Oracle 11g:

Put in json:

• https://jsao.io/2015/07/relational-to-json-with-pljson/
• http://www.toadworld.com/platforms/oracle/w/wiki/11661.introduction-to-json-with-oracle-database

Get json:

• http://obi2ru.blogspot.mx/2013/01/biee11g-list-of-dashboard-pages-by-plsql.html

Important links:

• https://www.morganslibrary.org/reference/pkgs/utl_tcp.html
• http://alex-td.blogspot.mx/2013/02/invoking-restful-web-service-in-oracle.html
• http://orclapex.blogspot.mx/2014/04/calling-apis-from-plsql-using-utlhttp.html
• https://oracle-base.com/articles/misc/apex_web_service-consuming-soap-and-rest-web-services
• https://community.oracle.com/thread/1037981
• https://stackoverflow.com/questions/25807835/old-sql-history-in-oracle-sql-developer

Best regards,

Remove "carriage return" from file under UNIX

Review a file with special characters: 
cat -v /home/user/example.sh

Remove carriage return(CR) from file:
perl -p -i -e "s/\r//g" /home/user/example.sh

Important links:
https://stackoverflow.com/questions/18125667/not-found-no-such-file-or-directory-error-even-though-the-file-present-in-tha

Best Regards,