Database
-
23ai 4000+ columns
Read more: 23ai 4000+ columnsYou may be of the belief that “nobody needs more than the 1000 columns we could create in a table in 19c”. You are free the believe that, but let me tell you a little story. There once was a project. At the height of the Telecom billing boom. Thy had implementations in multiple continents…
-
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…
-
![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…
-
23ai Select without FROM
Read more: 23ai Select without FROMNow that Oracle DB 23ai has been GA for a while I figure it is time to dig into it and talk about the features för DBA and developers that I find most interesting to talk about. Yes, you’ve read about some of them as info has seeped out during the beta-test and and pre-GA.…
-
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…
-
Graph is included in the DB – just the DB?
Read more: Graph is included in the DB – just the DB?Quite a few releases ago in 12c the new that the Graph and Spatial option was now included with the database license. Pretty neat, more stuff included is always nice. So in the database we can use the feature and even run queries against it. But then waht, we get a result back showing all…
-
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…
-
EZ Connect Plus
Read more: EZ Connect PlusSometimes new things that are really useful show up in new versions and you can miss it if you’r not paying close attention. EZ Connect Plus is one such feature for me. You may think it is not new and that it has been there for a long time. You’d be correct EZ Connect is…
-
Access Base DB from your PC
Read more: Access Base DB from your PCA recent post talked about setting up a Base DB Service in OCI and finished with logging into the OS of the srvice and there connecting to the DB. What we often want to do is to be able to connect to it directly from our own computer to use the tools and workflow we…
-
When TNS does not work in ORDS
Read more: When TNS does not work in ORDSThis is probably a short lived blog post. If you are using ORDS 22.4 (the current version as of this writing) you may encounter problems with the TNS-support for setting up connections. I believe they manifest when your TNS-entry has multiple hosts in them as you would if you have a setup with one or…
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)