Oracle – Temporary Table – Drop Table

February 8, 2023February 8, 2023 Daniel Adeniji ALL_TABLES ( Oracle – System View ), Engine ( Oracle - Database ), Oracle, Table ( Oracle - Database Engine ), Technical, Temporary Table ( Oracle - Database Engine - Table ), user_tables ( Oracle - System View ) Lance Devin

Background Using Temporary Table Outline Temporary Table Create Temporary Table Option:- On Commit On Commit Preserve Rows On Commit Delete Rows Discard all existing Data Truncate Table Insert Data Insert Data using "insert into" Fetch Data Fetch Data using "select" Truncate Data Truncate data from temporary table using "truncate table" Drop Table Drop Table Using … Continue reading Oracle – Temporary Table – Drop Table

Oracle – DATEDIFF Using Arithmetic

February 7, 2023February 8, 2023 Daniel Adeniji Anders Hejlsberg ( Software Engineer ), Danny Thorpe ( Software Engineer ), Engine ( Oracle - Database ), Oracle, Philippe Kahn ( Borland - CEO ), Technical Lance Devin

Background Earlier this week I needed to determine the difference between two dates. In Transact SQL, I will employ datediff. In Transact SQL, datediff allows one to compare two dates using years, months, days, hours, minutes in terms of measurement. Oracle Sample SQL Result Grid Image Textual friend DateMet nowUsingToChar nowUsingToCharFormatted numberofDaysFractional numberofDaysFractional ( 3 … Continue reading Oracle – DATEDIFF Using Arithmetic

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

December 24, 2020December 24, 2020 Daniel Adeniji Alex Poole ( Software Engineer - Oracle ), Jeff Smith ( Software Engineer - Oracle ), Oracle, Oracle SQL Developer Data Modeler, preferences ( Oracle - SQL Developer ), Technical spaces, tabs, whitespace

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 – DECODE – Check if two values are same

December 19, 2020December 20, 2020 Daniel Adeniji DECODE ( Oracle - PL/SQL - Function ), Oracle, PL/SQL, Technical, TRUNC (date) ( Oracle - PL/SQL - Function )

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

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

January 16, 2020July 2, 2020 Daniel Adeniji Ars Technica ( News Website ), File System ( Linux ), Jim Salter, Linus Torvalds, Linux ( OS ), Litigation ( Oracle ), Oracle, Technical, ZFS ( File System - Linux )

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

October 23, 2017October 23, 2017 Daniel Adeniji DBeaver, Oracle, Oracle Database JDBC Driver, Technical

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

August 30, 2016September 13, 2016 Daniel Adeniji Oracle, Oracle SQL Developer Data Modeler Cannot find a Java SE SDK installed at path, jdk, Please Specify the Path to the Java JDK home, sqldeveloper.conf

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)

October 16, 2013September 29, 2015 Daniel Adeniji Oracle SQL Developer Data Modeler Driver class not found. Verify the Driver Location, Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.

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

July 17, 2011July 17, 2011 Daniel Adeniji Oracle, Oracle - 11G - Client

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

Oracle – 11G – Client – SQL Developer (64-bit) – Error – WARNING: Could not find jvm.cfg!

June 24, 2011August 30, 2016 Daniel Adeniji Oracle, Oracle - 11G - Client, SQL Developer, Technical WARNING: Could not find jvm.cfg!

Introduction When the SQL Developer that is bundled with 64-bit Oracle 11G Client is launched, one is prompted for the location of java.exe. As the SQL Developer is running on a 64-bit system, the more natural choice is to go with 64-bit Java run-time. Doing so will be a mistake and if one would have done … Continue reading Oracle – 11G – Client – SQL Developer (64-bit) – Error – WARNING: Could not find jvm.cfg!