APEX APIs

Avatar Ashish Sahay Sep 17, 2021 1 min read Ashish SahayAPEXAPEXAPITHEMESBOILERPLATESPLUGIN
List of APEX APIs APEX_COLLECTION APEX_AUTOMATION APEX_CSS APEX_DATA_EXPORT APEX_DATA_PARSER APEX_DEBUG APEX_ESCAPE APEX_EXPORT APEX_IG APEX_IR APEX_ITEM APEX_JAVASCRIPT APEX_JSON APEX_LANG APEX_LDAP APEX_MAIL APEX_PAGE APEX_SESSION APEX_STRING APEX_WEB_SERVICE APEX_ZIP

JSON_TABLE

Avatar Ashish Sahay Sep 15, 2021 1 min read Ashish SahaySQLSQLSQLJSON_TABLE
JSON_TABLE Data retrievable / parsing using JSON_TABLE SELECT jt.* FROM json_table('JSON STRING', '$' COLUMNS ( "COLUMN_NAME" VARCHAR2(4000) PATH '$.JSON_KEY' .... .... , NESTED PATH '$.nested_array[*]' COLUMNS ( COL01 NUMBER PATH '$.COL01_PATH', COL02 VARCHAR(4000) PATH …

PLSQL Collection

Avatar Ashish Sahay Aug 7, 2021 1 min read Ashish SahayPLSQLPLSQLSQLPLSQL
PLSQL COLLECTION PL/SQL provides three collection types − Index-by tables or Associative array Syntax TYPE type_name IS TABLE OF element_type [NOT NULL] INDEX BY subscript_type; table_name type_name; Example TYPE l_tab_type IS TABLE OF NUMBER INDEX BY VARCHAR2(10); l_tab l_tab_type; Variable-size array or Varray TYPE …