Feb 08
In Oracle APEX, generating the application checksum is useful to compare if the application you have running in one workspace is an exact copy of the application running somewhere else. To create this checksum, you can go into Utilities -> Application Checksum. However, it is not very well documented how you could generate this checksum …
Dec 15
I had a requirement in one tool that I was working to find whether a given table column was power of 2. The easiest way to check would be using the LOG(2,y). If the result was an integer, the number would be power of 2. 2^X = Y -> LOG(2,Y)=X And …
Nov 30
In ORDS, I was working with a GET PL/SQL Handler and I need to produce an output variable inside a JSON Object. My ORDS version, as of today, is 22.1.6. Example: BEGIN ORDS.DEFINE_TEMPLATE( p_module_name => 'test', p_pattern => 'test', p_priority => 0, p_etag_type => 'HASH', p_etag_query => NULL, p_comments => NULL); ORDS.DEFINE_HANDLER( p_module_name => 'test', …
Nov 30
Those days, I had a requirement to create an ORDS endpoint that would call a dynamic SQL. Also, my ORDS endpoint was using a GTT and thus first I needed to load this table with some temporary data. Thus, I was left with no other option than using the PL/SQL handler type in my ORDS. …
Nov 14
Below are the 3 views that will list the tables with identity columns in Oracle: USER_TAB_IDENTITY_COLS ALL_TAB_IDENTITY_COLS DBA_TAB_IDENTITY_COLS PS: I know this post does not make any sense, but sometimes I try to quickly find those table names in Google and for whatever reason, Google Indexer can't find proper websites. So I make this …
Rodrigo Jorge
Oracle OCM Database 11g & 12c
Oracle OCM MAA & Cloud
Oracle OCE Data Guard 12c
Oracle OCE RAC and Grid 11gR2 & 12c
Oracle OCE Performance Tuning 11g & 12c
Oracle OCS Security 11g
Oracle OCS Data Warehousing 11g
