Background Story time When I just started Working as a DBA, the Senior Database Administrator was taking me over the environment and how things are set up with all the servers, databases, applications and all that. He was talking about one of the purchased applications that run on production and then explained that the vendor […]
BACKGROUND Working in IT is one of those things, you love it but sometimes it can annoy the hell out of you and this is extremely frustrating. You wake up in the morning, come to work, have plans of what you’re going to do and then… All hell breaks loose. It can be exciting and
The ORA-01017 invalid username/password; logon denied Read More »
Background Oracle AI Database 26ai provides new, easier and self documenting syntax for insert statements: Non-positional Inserts. This makes use of the INSERT INTO SET and BY NAME clauses The SET clause works similarly to the existing set clause for update statements, and the by name clause makes it easier to insert the results of
Non-Positional Inserts in Oracle AI Database 26ai Read More »
The Qualify clause in Oracle database 26ai makes it easier to filter on the results of window functions. See an example in this blog post.
Easier filtering of window functions with the Qualify clause in oracle AI Database 26ai Read More »
Database constraints enable developers to enforce business rules and data integrity right at the true source of the data, the tables! They help do things like ensure data uniqueness in a table, prevent incorrect data from being keyed in, prevent null values and enforce relationships between tables to name a few. Typical constraints (Primary key,
Background Historically, updating a table based on values from another table in oracle database required developers to rely on correlated subqueries and or merge statements or other workarounds. Oracle ai database 26ai allows tables to be joined directly using an update and/or a delete statement. The result is cleaner SQL, more intuitive data modification queries,
Simpler Update and Delete logic with direct joins in Oracle 26ai Read More »
Using Nano Editor on Linux GNU nano is an easy to use command line text editor for Unix and Linux operating systems(including Oracle Linux). It includes all the basic functionality you’d expect from a regular text editor, like syntax highlighting, multiple buffers, search and replace with regular expression support, spellchecking, UTF-8 encoding, and more. It is
I was attempting to do some work on one of the databases on a sandbox environment that had been shutdown for a few weeks; so I log on to the server, set my environment, connect as sys, issue the startup command and… I get the ORA-03113: end of file on communication channel! This was somewhat
Guaranteed Restore Points bring a welcome sense of certainty to Oracle environments, especially when you’re navigating high‑risk changes like patching, data migrations, or application rollouts. By preserving a precise, immutable point in time, they give DBAs the confidence to experiment, recover quickly, and protect business continuity without relying solely on full backups. When used thoughtfully—paired with solid monitoring and storage awareness—GRPs become a powerful safety net that transforms recovery from a stressful gamble into a predictable, controlled process.
A BRIEF PRIMER: VIEWS Views are a great feature of the database, they are stored SQL queries that can be reused again and again without the need for rewriting the entire code. If a view has a filter in it however, and maybe you want to see the same resulting columns that the view generates
Creating “views” That accept input using SQL Macros Read More »
