Oracle – SQL Developer – Customize – Editing – Preferences – Tabs Versus Spaces

Background Let us begin the process of customizing our SQL Developer Editor. Outline Preference Tabs Versus Spaces Show White Spaces Tasks Preferences Preference - Tabs Versus Spaces Outline Access Menu Access the Menu and select Tools and Preferences In the Preferences Window Within the left navigator tree, access the options Code Editor / Format / … Continue reading Oracle – SQL Developer – Customize – Editing – Preferences – Tabs Versus Spaces

Oracle – SQL Developer – Installation ( v20.2 )

Background There are a few things I am unable to do with DBeaver while connected to an Oracle instance. Let us see if SQL Developer will get around the nook. Outline Artifact Identify Artifact Source Available Artifacts Identify Artifact Download Artifact Install Artifact Launch Application Use Application Configure   Artifact Identify Artifact Source Oracle SQL … Continue reading Oracle – SQL Developer – Installation ( v20.2 )

Oracle – DECODE – Check if two values are same

Background Looking at some sample code. The purpose of the decode function was lost on me until I looked at it more. Code Output   Source Code Gist DanielAdeniji/OracleDecodeCompareDates.sql Link   Summary Took to the lab and confirmed that decode was simply used to compare if the first two values are same. If same, return … Continue reading Oracle – DECODE – Check if two values are same

Oracle:- PL/SQL – DECODE Function

Background Reviewing someone's SQL and needing to wrap my head around the Decode Function. Transact SQL Transact SQL does not offer the Decode Function and henceforth it always trips me.   Oracle - PL/SQL - Sample DDL DML DML - Data Add DML - Data Query DML - Data Query - 01 Query Filler returned … Continue reading Oracle:- PL/SQL – DECODE Function

Magazine:- “Database – Trends and Applications” – Readers Choice Awards – 2020

Readers Choice Awards The Magazine "Database Trends and Applications" has out its Readers Choice Awards for 2020. The list is available here. Here is what it looks like. Best Cloud Database Winner Amazon RDS Finalists Microsoft Azure Couchbase Cloud Best Cloud Database Winner Microsoft Azure Finalists Amazon Web Services Quest Software Spotlight Cloud Data Lake … Continue reading Magazine:- “Database – Trends and Applications” – Readers Choice Awards – 2020

Ars Technica – Jim Salter :- Linus Torvalds on ZFS File System – Rebuttal

Background I like Google News as it offers an aggregated snapshot of the days trending news. I caught wind of Linus Torvalds take on the ZFS File System and his reticence to merge it into Linux Core. The reason he cited is Oracle's litigious posture. Jim Salter's Response Link Introduction Last Monday in the "Moderated … Continue reading Ars Technica – Jim Salter :- Linus Torvalds on ZFS File System – Rebuttal

DBeaver – Database Connection Configuration – Oracle – Oracle JDBC Driver

Background Towards a couple of sample Oracle Database sample exercises that we have in mind wanted to make sure that our all purpose database client, DBeaver, is able to communicate with an Oracle Database.   Preparation Oracle Java Version Objective The version of JDBC Client that we need will be based on the version of … Continue reading DBeaver – Database Connection Configuration – Oracle – Oracle JDBC Driver

SQL Developer – Cannot find a Java SE SDK installed at path

Background Back in 2011, 5 years ago now, I posted about an error message I was experiencing. The error message reads "Oracle – 11G – Client – SQL Developer (64-bit) – Error – WARNING: Could not find jvm.cfg!". And, it is available here.   Last Week In the last week I have received a couple … Continue reading SQL Developer – Cannot find a Java SE SDK installed at path

Database – Modeling – Oracle SQL Developer Data Modeler (v 3.3)

Introduction In the thick of converting from a legacy database to a new system and thank goodness the legacy system has well defined relationship mappings (Primary Key and Foreign Keys). And, this will help my familiarization. It always helps to look at a diagram and make sure that my relationships are maintained in the new DB. Potential … Continue reading Database – Modeling – Oracle SQL Developer Data Modeler (v 3.3)

Oracle – 11 G/R2 Client – Install – Error moving orandce11.dll.dbl

Tried installing Oracle 11G/R2, but failing saying that it could not move orandce11.dbl.dll: INFO: moving 'E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll.dbl' to 'E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll' INFO: moving 'E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll.dbl' to 'E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll' INFO: Exception thrown from action: moveFile Exception Name: FileNotFoundException Exception String: File not found E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll.dbl Exception Severity: 2 INFO: Exception handling set to prompt user with options to Retry Ignore User Choice: … Continue reading Oracle – 11 G/R2 Client – Install – Error moving orandce11.dll.dbl