ORA-00972: identifier is too long

ORA-00972: identifier is too long. Till Oracle 12 C, the identifier length is 30 characters. Starting from 18 C Oracle increased the length of identifier to 128 character. So now we can define our identifiers till 128 characters if you have upgraded to 18 C. Let see one example. Database version 18 C. Select ename as …

Add Website rss feed to the Blogger

How to Add Website rss feed to the Blogger? Go to blogger Dashboard, open Layout. Now we need to add a widget to the layout. Click on add Widget or Gadget. As click on add a widget then you can see google layout widgets available to add. scroll to “Feed” Feed can provide you the option to fetch the …

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', …