SQL
-
23ai Lock-free reservations
Read more: 23ai Lock-free reservationsAn old truth in Oracle and just about all relational databases has been that an update on one row by one session will block an update by another session on the same row. Until the first session commits or rolls back. That is until 23ai. Or at least in some very specific scenarios. Let’s consider…
-
Troubleshooting conversion errors
Read more: Troubleshooting conversion errorsMy friend and Oracle maestro Daniel Ekberg wrote a post about ways to manage errors when converting data. Go read his post if you want to see how the errors you get can be better managed. I think he may be the person that first pointed out the feature to me that I want to…
-
![23ai Syntactic sugar – IF [NOT] EXIST](https://mathiasmagnusson.com/wp-content/uploads/sites/3/2024/06/DALL·E-2024-06-08-22.19.55-A-cartoonish-scene-depicting-a-computer-science-professor-in-his-late-40s-with-wild-graying-hair-and-a-beard-wearing-a-lab-coat-and-glasses.-He-look.jpeg)
23ai Syntactic sugar – IF [NOT] EXIST
Read more: 23ai Syntactic sugar – IF [NOT] EXISTIn the last post I talked about a form of syntactic sugar I’m not convinced we really needed. This post on the other hand is about one that I think I’ve needed since the first time I logged on to a SQL-based database. When you put together a test case it is often setup to…
-
Your very first graph in Oracle Graph Server
Read more: Your very first graph in Oracle Graph ServerHaving installed the Graph Server in the last post, lets set up and create your very first graph. This follows Oracles documentation. It however had different ways to do it and I struggled to figure out which would be the easiest. Having abandoned a couple for different reasons this is how I did it and…
-
Looking for AI? You already have it!
Read more: Looking for AI? You already have it!These days I meet many people who talk about how they have a project to find an AI-plattform to use on-premises. Using it in the cloud on Autonomous it is pretty obvious that you use one in a handful of AI-services Oracle has at your disposal there. The question is what you should use to…
-
Ignoring errors on “alter session set”
Read more: Ignoring errors on “alter session set”This tip is especially useful when migrating to autonomous. The reason is that to enable the magic of the the autonomous database there are things that cannot be done. One such thing is that there are a lot of session settings you cannot use. To see what APIs you can no longer use you can…
-
Using package variables in SQL
Read more: Using package variables in SQLI often want to use the constants defined in packages also in my SQL. It has in the past never worked and it for the most part still does not. If I have a a package like this to simplify my code for what department it is I’m looking at. This now allows using dept_info.c_accounting…
-
Add hint to SQL you cannot modify
Read more: Add hint to SQL you cannot modifyThe last post showed how to lock the plan for a SQL that switched plan every now and then. Another common issue one can encounter is that of a SQL that uses a suboptimal plan and for which you’d want it to use a different plan. The way to instruct the optimiser to use a…
-
Lock the plan for a SQL
Read more: Lock the plan for a SQLA SQL that sometimes just uses a plan you prefer it to not use is fairly common. There are always reasons for unstable plans, but more important than knowing the reason is often to make it stick to a certain plan. This has historically been done with a lots of ways from changing the SQL,…
-
Set operators – Union, intersect and minus
Read more: Set operators – Union, intersect and minusYou’ve probably combined two queries with “union”, but have you looked at the different options for how to combine queries? The set operators are more combining result sets than they are combining queries even if we often think about it is combined queries. Thy need to return the same number of columns of the same…
Subscribe
Sign up with your email address to receive our weekly news
Latest news
- 23ai 4000+ columns
- 23ai Lock-free reservations
- Troubleshooting conversion errors
- 23ai Syntactic sugar – IF [NOT] EXIST
- 23ai Select without FROM
Categories
- Alert Log (4)
- APEX (25)
- AQ (1)
- Article (1)
- Back To Basics (2)
- Blogging (10)
- Books (1)
- Bug (4)
- Business (1)
- Challenge (2)
- Commit (2)
- Database (16)
- DBA (24)
- Docker (4)
- EXA (1)
- Humor (1)
- I/O (2)
- ITL (1)
- JoelKallmanDay (1)
- Licensing (3)
- Machine Learning (1)
- MultiTenant (2)
- New Stuff (2)
- OOW (12)
- Oracle (36)
- Oracle Cloud (7)
- Oracle DB 23ai (3)
- Oracle Developer Tools (3)
- ORDS (10)
- OTN (1)
- Partitioning (6)
- Performance (19)
- Perl (1)
- PL/SQL (7)
- Presenting (2)
- Property Graph (1)
- Python (2)
- RSS (2)
- Security (3)
- SQL (34)
- SQL Developer (3)
- SQLcl (5)
- ThanksODC (1)
- Uncategorized (6)
- Undo (1)
- Versioning (1)
- Virtualization (2)
- Visual Code (4)
- Wallet (3)
- XML (4)