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…
-
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…
-
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…
-
You ought to have oracledb in your tool chest
Read more: You ought to have oracledb in your tool chestNo I’m not talking about the Oracle Database. It is extremely unlikely that you found your way here if it isn’t already to some extent your specialisation. If you made it here and have no idea what this is about, drop a comment and let me know your path here if that were to be…
-
Longs in SQL
Read more: Longs in SQLUsing long datatype is a problem we seldom face with new applications. But some old may still have it if they have not managed to convert to somethings easier to work with. But where I most often encounter it is in Oracles tables. The place that by far most often pops up its ugly head…
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)