Print CLOB Content in Oracle Apex

How to show clob content in oracle apex page ? is it possible to show ? Yes, Possible to print clob content in oracle apex page with using of PL/SQL Dynamic Content Region. Step 1: Split CLOB content into small pieces of content with using of dbms_lob.read¬†procedure. Example Code Snippet: DECLARE CURSOR crec IS SELECT html_message FROM mails_t WHERE email_id = 1001; rrec crec%rowtype; l_amt … Continue reading Print CLOB Content in Oracle Apex

Oracle Apex Use of apex_web_service.make_rest_request

Instead of use UTL_HTTP.BEGIN_REQUEST in PL/SQL oracle apex offered to make web service request through “apex_web_service.make_rest_request” API.  Example Web Service Sample URL: http://quotes.rest/qod.json Syntax:- DECLARE l_response CLOB; BEGIN l_response:= apex_web_service.make_rest_request(p_url => ‘http://quotes.rest/qod.json’, p_http_method => ‘GET’ ); END; Webservice Response:- { “success”: { “total”: 1 }, “contents”: { “quotes”: [ { “quote”: “If you want to test your memory, try to recall what you were worrying about … Continue reading Oracle Apex Use of apex_web_service.make_rest_request

Get domain name from Email in Oracle SQL

How to get domain name from given email id in Oracle SQL (or) PL/SQL Very easy to get domain name from mail id like ‘thamaraiapex@gmail.com’ =>¬†gmail SELECT (substr(substr(‘thamaraiapex@gmail.com’, instr(‘thamaraiapex@gmail.com’, ‘@’) + 1), 1, instr(substr(‘thamaraiapex@gmail.com’, instr(‘thamaraiapex@gmail.com’, ‘@’) + 1), ‘.’) – 1)) as domain_name FROM dual; Result:- gmail Continue reading Get domain name from Email in Oracle SQL