Home
More icon
Categories Tags
Links icon
Apex Tutorials Web Development
About
  • Get Images from ORACLE REST Web Service

    Posted by - Ashish Sahay Apr 6, 2020 APEX PLSQL SQL API

    How to get Images from ORACLE REST Web Service ? Oracle REST APIs provides the feature of media resource, here we can write the query with two columns content type and image blob. While i was trying to implement i saw tweaks, the query has to be in below format only. 1SELECT 'content_type', 2 column 3 FROM . . …

    Read More
  • Consuming ORDS Rest APIs using PL/SQL

    Posted by - Ashish Sahay Feb 29, 2020 APEX PLSQL ORDS API

    Consuming ORDS Rest APIs using PL/SQL 1API End point : https://apex.oracle.com/pls/apex/ashish_portfolio/hr/test_emp 2 3Parameters : deptno, empno 4 5Method : GET 6 Without parameters 1Declare 2 l_clob CLOB; 3BEGIN 4 l_clob := APEX_WEB_SERVICE.make_rest_request( 5 p_url => …

    Read More
  • Restful API using ORDS

    Posted by - Ashish Sahay Feb 29, 2020 APEX ORDS API

    Creating Rest API using ORDS ORDS APIs follows the Module, Template, Method. Now let see the Hierarchy of these. Module is top level container, it can contain set of templates . Template is at second level container can contain multiple Handlers. Handler is logical area where the purpose needs to define or what are …

    Read More

Ontoor Soluions


APEX, PLSQL and Web development Blogs
Read More

Featured Posts

Recent Posts

  • Dynamic position Navigation Menu Oracle Apex
  • Add Tooltip on Side Navigation Menu Oracle APEX
  • Creating a custom template oracle apex part-1
  • Add Search Option On Nav Bar Oracle Apex
  • Refresh region of base page when closing modal dialog | Oracle APEX
  • Interactive Grid Checkbox
  • Mega Menu Oracle Apex
  • Table Blob to Oracle Directory

categories

APEX 97 ORACLE 24 PLSQL 13 DBA 5 GITHUB 4 BLOGGER 3 JAVASCRIPT 3 ORDS 3 APEX_JSON 2 CSS 1 PLSQLAPEX_WEB_SERVICE 1 PLUGIN 1 SCRUM 1 SQL 1

tags

PLSQL 104 APEX 101 SQL 93 ORACLE 32 PLUGINS 23 TEMPLATES 14 DYNAMIC-ACTION 9 ONTOORPLUGINS 9 JAVASCRIPT 7 CLASSIC-REPORT 5 DBA 5 UNIVERSAL-THEME 4 API 3 BLOGGER 3
All tags
AGILE1 APEX101 APEX+CSS2 APEX-20.11 APEX-AND-CSS1 APEX.SERVER2 APEX_DATA_PARSER1 APEX_DATA_PASER2 APEX_JSON2 APEX_UTIL1 APEX_WEB_SERVICE2 APEX_ZIP1 API3 BLOB1 BLOGGER3 CASCADE1 CLASSIC-REPORT5 CLOB1 COALESCE2 CSS3 CUSTOM1 DBA5 DBMS_LOB2 DELETED1 DIRECTORY1 DOWNLOAD1 DYNAMIC-ACTION9 FUNCTION1 GITHUB3 GOOGLE2 HTML1 IG1 INDEX1 INTERACTIVE-ACTIVE1 INTERACTIVE-GRID2 INTERACTIVE-REPORT2 IR1 ITEM2 JAVASCRIPT7 JQUERY1 LOV1 MARKDOWN2 MEGA-MENU1 NAVIGATION1 NEW-LINE1 NULL1 NULLIF1 NVL1 NVL21 ONTOORPLUGINS9 ORA1 ORACLE32 ORACLE_TO_XML1 ORDS3 PAGE1 PAGE-GROUP1 PAGE-ZERO1 PIPELINE1 PLSQL104 PLUGINS23 POP-UP-LOV1 RDS2 REPLACE1 RSS1 SCRUM1 SELECT-LIST1 SPECIAL-CHARACTER1 SQL93 STICKY1 SUBSCRIPTIONS1 SYS_CONTEXT1 TABULAR-FORM1 TEMPLATE2 TEMPLATES14 UI3 UNIVERSAL-THEME4 USER-STORIES1 UTL_FILE1 WEB_SOURCE1
[A~Z][0~9]

Tweets by OntoorSolutions

Copyright ©   Ontoor Solutions Blogs. All Rights Reserved