Presented at Quest Experience Week (QXW) – Database & Technology Day
One of the most critical aspects of building effective systems is the successful management of unstructured/semi-structured information. The database is no longer only a place to store dollars and cents for the purposes of accounting. Efficient manipulation of JSON has become one of the most critical elements of contemporary database infrastructure. Even though you can store JSON documents in VARCHAR2 columns, in reality, you will quickly outgrow VARCHAR2 size limitations and will have to switch to LOBs for storage. However, few people in the development community really understand the underlying mechanics of Oracle LOB datatypes and consider it yet another DBA issue. This presentation attempts to fill that knowledge gap.