All about my opinions on IT and much, much more …
I got an interesting question the other day: “which Oracle Database Parameters are PDB-modifiable?”, i.e., which parameters can have different values for an individual PDB than the CDB? Looking into the documentation, I realized there is no good one-stop page. Instead, the information is scattered throughout the Database Reference. Luckily, however, the answer can be retrieved from the database itself by querying the v$parameters system view.
Oracle Database 23c Free – Developer Release is a new, free offering of the industry-leading Oracle Database that enterprises worldwide rely on every day. It can be downloaded straight from the Internet with no oracle.com user account or license click-through requirements, enabling simple and fast access to the world’s only converged database that supports all data models and workload types.
Oracle Database 23c Free – Developer Release is packaged for ease of use and a full-featured experience, making it the perfect entry-level database for anyone who wants to build and run data-driven apps. Its built-in upward compatibility with Oracle Database Enterprise Edition and Oracle Database cloud services ensures that users can move to any other Oracle Database offering anytime.
Continue reading “Introducing Oracle Database 23c Free – Developer Release”
Have you ever encountered a situation when you were in the middle of writing a SQL query and thought, “if only I could write a quick PL/SQL function for this, it would make this quick and easy?” But, unfortunately, you don’t have any privileges to create any functions in the schema. Luckily, since Oracle Database 12c, there is an answer for you.
Continue reading “How to write an anonymous PL/SQL function and use it in your SQL statement”
This is a short blog post about a tiny little feature that you are probably unaware of but can make your life easier.
When you work with databases, you sometimes may find yourself in a situation where you got a long-running query because you forgot a WHERE clause or you didn’t realize how many rows the table had, and you wished you could stop the query but not kill your entire database session in the process.
Say you have a transaction running, and now you want to verify your changes before committing but, oh no, you messed up the WHERE clause and the query goes off for a while. What are you going to do? Kill the session but have to redo the entire transaction again, or wait it out but it could be quite a while. Well, if you are on Oracle Database 18c or later, you will find yourself in luck. Say hello to ALTER SYSTEM CANCEL SQL!
One of the things that kept me busy lately was experimenting with how much an Oracle XE database setup could be streamlined inside a Docker image for things like CI/CD consumption. Pretty much ever since I put together the first official build scripts for Oracle Database, people have asked for faster image pull and startup times to speed up their continuous integration tests. A lot of things have changed since then, and I’m happy that my engineering colleagues at Oracle have taken on the maintenance and further enhancements of Oracle’s official Docker build files and images, and integrated them into the internal processes.
Continue reading “Introducing gvenzl/oracle-xe: Oracle Database XE Docker images”
Gerald on IT 