-
Keeping my SQLcl toasty fresh!
With the recent change to the licensing rules for SQLcl, a simple “yum” command on your Linux box gets you up and running with SQLcl in just a few keystrokes, and for most of my VM’s that is the way I roll. However, for some environments I work with, I don’t have necessary privileges to Read more
-
New podcast episode! ORACLE-BASE enters the chat
What happens when you get two mates who haven’t had a chance to catch up at a conference like they normally would? You get a lot of chit-chat! Chances are, if you have Googled for help on an Oracle problem, you have ended up on a concise yet precise solution to your problem at oracle-base.com. Read more
-
19c Express Edition #JoelKallmanDay
Since 18c, Express Edition (XE) has typically been my “Go-To” release of the Oracle Database. It is free, quick to install, contains virtually no limitations on the features and options that you are permitted to use and has sufficient space for me to hold a clone of the AskTom schema so I can test AskTom Read more
-
The HOST command in SQL*Plus and SQLcl
Truth be told, the original title of this post was going to be “How I lost an entire day debugging datapatch which I thought had totally borked my database when trying to apply patch 19.12” but after some reflection and a few gin and tonics I’ve calmed down enough to describe the situation with more Read more
-
Get the SQL_ID for a SQL statement BEFORE you run it
An AskTom customer asked the question recently: “We often use the SQL_ID to dig into the performance views once we have run a statement, but can we know what the SQL_ID for a statement will be in advance?” Normally this is a question I would not have probably considered “blog worthy” because it is a Read more
-
Integration with SQL
A friend threw me a puzzle yesterday which I thought would be challenging, but turned out to be easy to solve with SQL. Such is the wonder of the SQL language! The challenge is simple: Given a function, can we use SQL to integrate that function over a range? Not every function has an integral, Read more
-
EZconnect for SQL*Plus
Just a quick tip to solve a common issue that is catching people out. The EZconnect syntax is a great way of connecting to the database without all the rigmarole of setting up and maintaining a tnsnames.ora file. You just nominate the host, service, and optionally the port and away you go. SQL> connect scott/tiger@//localhost:1519/pdb1 Read more
-
21cXE – post install tip
Hopefully by now you have seen the buzz about the release of 21c Express Edition (XE) and here’s a walkthrough on how you install it with just a few clicks. But if you’re “old school” and like using a tnsname entry to connect to your database, there is one additional step that will make your Read more
-
Is my table temporal?
Just a quick post in response to a question that came from Oracle Ace Alex Nuijten recently. He asked if you define a table using the temporal validity feature in Oracle, for example, SQL> create table t ( 2 id number(10) not null, 3 blah number(10) not null, 4 start_date date, 5 end_date date, 6 Read more
-
SQL trace on your cloud database
There are so many great performance monitoring tools that have come along in the Oracle Database since 10g – things like AWR, ASH, ADDM, SPM…the list of acronyms is seemingly endless But sometimes, for those really really hard to nut out problems, you need to go back to one of the fundamental diagnostic tools: SQL Read more
-
Can you solve this blocksize puzzle?
Here’s a little puzzle to get your mind working It is generally well known that there is a limit to the length of an index key in the Oracle database, the length being related to the block size for your database, or the block size of the tablespace where you are trying to create that Read more
-
New Podcast Episode! The most important skill you need
If you’re an Oracle developer, pause for a second and ponder this question: What is the most important skill you need to be a successful developer? Is it database modelling? Is it SQL coding? Is it being able write Java, C#, or [insert favourite 3GL here] ? Is it being able to talk to customers? Read more
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 