First Commit to Github

First Commit to GITHUB Github commits pretty much follows by the user changes has been made on the branch. So here is the thing, you made the changes then you can stage them and at last you can push them origin branch. $ git status On branch master Your branch is up to date with 'origin/master'. nothing to …

Solving Github Commit Conflicts

How to solve GITHUB Commit Conflicts? What are GIT commit conflicts? As a flexible version control system, GIT provides a great feature of committing changes to the local branch to the origin branch. So since it pretty easy to commit then why conflicts? And the answer is.. If you are trying to commit one of you changes …

APEX page types | Universal Theme

APEX provides three types of pages till APEX 20. To create these pages Select Page Mode. Page Mode Select the page mode for this page. Available options include: Normal The page is presented as a normal Application Express application page. Modal Dialog The page is presented as a modal dialog. A modal dialog is …

Blob to Clob Using DBMS_LOB

Create function to convert the blob content to clob CREATE OR REPLACE FUNCTION blob_to_clob (i_blob_content IN BLOB) RETURN CLOB AS l_chunk VARCHAR2 (32767); l_position PLS_INTEGER := 1; l_buffer_size PLS_INTEGER := 32767; l_clob_text CLOB; BEGIN -- Create temprary DBMS_LOB.createtemporary (l_clob_text, TRUE); FOR i …

Restful API using ORDS

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 …

Getting into ORDS

Firstly we need to enable ORDS. Base url : <SERVER_URL>:<SERVER_PORT>/ords/ To hide the schema name from API endpoint we put any alias in url mapping pattern. BEGIN ORDS.enable_schema( p_enabled => TRUE, p_schema => '<SCHEMA_NAME>', p_url_mapping_type => 'BASE_PATH', …

CLOB to BLOB using PLSQL

Create function to convert the CLOB to BLOB CREATE OR REPLACE FUNCTION clob_to_blob (i_clob_text IN CLOB) RETURN BLOB IS /* Version 1 29-mar-2020 */ l_blob_file BLOB; l_lob_length PLS_INTEGER := DBMS_LOB.getlength (i_clob_text); l_position PLS_INTEGER := 1; l_buffer_size RAW (32767); BEGIN DBMS_LOB.createtemporary …

APEX Page Group

Page groups are very helpful for developers to manage application pages. Developer can use Page Groups to club the similar kind of Pages. These groups give the a centralized management for pages, For example if developer needs to build an application which includes around 10 to 15 modules then it will become hard to …

Create ZIP File using APEX_ZIP

Data Types The data types used by the APEX_ZIP package. t_files type t_files is table of varchar2(32767) index by binary_integer; declare l_zip_file blob; begin for l_file in ( select file_name, file_content from my_files ) loop apex_zip.add_file ( p_zipped_blob => l_zip_file, p_file_name => l_file.file_name, …