Table of Contents Table of Contents List of Examples List of Figures List of Tables Title and Copyright Information Send Us Your Comments Preface Audience Customer Support Review Patch Documentation Improved Process for Oracle Retail Documentation Corrections Oracle Help Center (docs.oracle.com) Conventions 1 Introduction What is DDS? Need for DDS Functionality Offered Accessibility 2 RESTful Services Discover Get Data Get Data from a Table Insert Data Update Data Delete Data Get Schemas Get Tables Get Columns for a Table Get System Options Create System Options Update System Options Delete System Options Reset Cache 3 Security Table Level Security IDCS Security Setup Create OAuth2 Client Application in IDCS 4 User Interface Admin Tab Guide Initial Permissions Setup Manage Access Levels Manage Security Groups Manage Security Permissions Designer Tab Guide Table Definition Query Builder 5 Advanced Backend Features LIKE Statement IN Statement Comparative Operators Filtering DATE Column Combinations of OR, AND & BETWEEN Statements Viewing Clob Data Viewing Query Response as JSON Data JOINing Two or More Tables Count of Records