-
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
-
Before you case-insensitive your whole database!
(Familiar with case-insenstive collation already? Skip ahead to the “Side Effects”) A history of failed applications Before Oracle 12, a common cause of frustration was how to easily handle the case of character data in your applications. It is day 1 of your application being live, and a simple query on your database suggests that… Read more
-
21c … a more secure DataPump
With the new release of every product from every software vendor, there are always the big banner headline features that take up all the marketing “real estate”, and 21c will be no exception. These features will certainly get their fair share of attention from the blog-sphere, the official media releases, documentation and the like. But… Read more
-
21c database creation seems to hang
Just a quick tip that caught me out when creating my 21c database with the Database Creation Assistant. Once you have answered all of the prompts and the creation of the database begins in earnest, there is an unnerving moment where the entire process seems to stall. In reality, it is just an unfortunate coincidence… Read more
-
21c software installation OS groups
Before your 21c database software installation, there are a number of prerequisite steps in order to get your operating system ready for the Oracle Database. This used to be a lengthy series of manual tasks, but more recently this has been simplified with the preinstall rpm file that we make available to you. [root@localhost sf_tmp]#… Read more
-
21c software … where did everything go?
Now that 21c is out and you’re all busily downloading it to explore on your local servers, the twitter DMs have already started to come in. Now I can’t detect a panicked tone from the written word, but if I had to guess, there is definitely some panic out there , and most of it… Read more
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 