How to get all historical changes on default values of Oracle Database parameters
DBA – Rodrigo Jorge – Oracle Dicas e Guias
by DBA RJ
1M ago
Whenever we patch, upgrade, or migrate our database server, it is important to track what changes we have between the source/target release or patch level to track any possible regressions. One of the things I've been struggling with for years is how to track all the changes that happen to database parameters (including the underscores). … The post How to get all historical changes on default values of Oracle Database parameters appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
Visit website
How to check the code of the most important Oracle internal objects without having a database
DBA – Rodrigo Jorge – Oracle Dicas e Guias
by DBA RJ
4M ago
Sometimes, I have to debug and troubleshoot something, and I see myself in a position where I need to get the dictionary code of internal Oracle objects, and the most common way to do that is using DBMS_METADATA. Let's say, for example, that I need to get the view SQL code for DBA_USERS we had … The post How to check the code of the most important Oracle internal objects without having a database appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
Visit website
How get the contents of the most important Oracle internal views without having a database
DBA – Rodrigo Jorge – Oracle Dicas e Guias
by DBA RJ
4M ago
In my daily work, sometimes I see myself in a position that I need to get the vision of an Oracle dictionary table for a specific release. Let's say, for example, that I need to get the list of all parameters we had back in 12.1.0.2 with July 2021 patch applied. Or maybe, what if … The post How get the contents of the most important Oracle internal views without having a database appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
Visit website
What is new in Oracle Database 19.21 RU
DBA – Rodrigo Jorge – Oracle Dicas e Guias
by DBA RJ
5M ago
Oracle Database 19.21 RU was just released! As soon as it is available in My Oracle Support to download, we also add it to ORAdiff app: https://oradiff.oracle.com/ So, what is new? You can check yourself by accessing ORAdiff website and comparing each section, but below I will give a summary of the main changes that … The post What is new in Oracle Database 19.21 RU appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
Visit website
LAOUC 2023 Slides
DBA – Rodrigo Jorge – Oracle Dicas e Guias
by DBA RJ
7M ago
After 2 intensive weeks, the LAOUC Tour 2023 is over! It was the first tour after the 2019 pandemic and it was great to see all that legion of people interested in Oracle technologies. Over the 7 countries that I've visited during the tour, I gave the 4 sessions above: Secret Features of Oracle Data … The post LAOUC 2023 Slides appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
Visit website
LOG(x,y) returning wrong results in some cases
DBA – Rodrigo Jorge – Oracle Dicas e Guias
by DBA RJ
1y ago
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 … The post LOG(x,y) returning wrong results in some cases appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
Visit website
ORDS output variable inside a JSON Object
DBA – Rodrigo Jorge – Oracle Dicas e Guias
by DBA RJ
1y ago
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', … The post ORDS output variable inside a JSON Object appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
Visit website
ORDS pagination with PL/SQL source type
DBA – Rodrigo Jorge – Oracle Dicas e Guias
by DBA RJ
1y ago
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. … The post ORDS pagination with PL/SQL source type appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
Visit website
List tables with identity column oracle
DBA – Rodrigo Jorge – Oracle Dicas e Guias
by DBA RJ
1y ago
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 … The post List tables with identity column oracle appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
Visit website
Oracle ORDS returns RAW columns as base64 encoding
DBA – Rodrigo Jorge – Oracle Dicas e Guias
by DBA RJ
1y ago
Those days, I was building a REST API service for retrieving the columns of a checksum table. The table structure was pretty simple: CREATE TABLE "DEMO" ( "PATH" VARCHAR2(500 CHAR), "MD5_HASH" RAW(16) ); INSERT INTO DEMO ( PATH, MD5_HASH ) VALUES ( 'bundle.xml', '70D53BE37073B31347EE42B622EA4A75' ); COMMIT; So, as you can see, very simple table with … The post Oracle ORDS returns RAW columns as base64 encoding appeared first on DBA - Rodrigo Jorge - Oracle Tips and Guides ..read more
Visit website

Follow DBA – Rodrigo Jorge – Oracle Dicas e Guias on FeedSpot

Continue with Google
Continue with Apple
OR