-
Navigating the Oracle Database documentation
Last year alongside the release of Oracle Database 23c, we made some UI changes to the documentation. Tim Hall did a review of the changes and had one major criticism. A number of people (both internal and external to Oracle) agreed with that sentiment. If you looked at the way the docs worked before this Read more
-
SQL … I am so confused
I poke around the internet a little bit, and I often stumble upon content like the following: That kind of stuff absolutely bamboozles me. I’ve been around the IT industry for, well, lets just say “a number of years” 😂 and a consequence of that duration is that I’ve worked with a lot of languages. Read more
-
CloudWorld–Thursday
I’m going to have to be up front with you here. If your focus is Database, then Thursday is going to be a nightmare because every timeslot has a plethora of “must not miss” sessions. My best advice to you would to be either bring a friend, or make some new friends at the conference Read more
-
CloudWorld Agenda and … APEX!
Yes folks it’s back! My strictly off the books, strictly unofficial CloudWorld agenda app in APEX is back for another year. The easy, fast and flexible faceted search of APEX that you know and love, combined with the ability to download calendar entries for the sessions you want to see at CloudWorld, and most importantly Read more
-
CloudWorld–Wednesday
Well surely there is not better way to start Wednesday with a fine breakfast of 23ai demos at my session . No slides, no marketing – just 100% demo of the cool stuff in 23ai. Come along as say Hi! and see what 23ai has to offer. If you are a developer interested how you’ll Read more
-
CloudWorld–Tuesday
Welcome to second four posts covering the four days of CloudWorld 2024. Here’s my recommendations for how to spend your time on Tuesday. Tuesday is typically keynote day at CloudWorld, but I’ve also added some sessions and labs for those who want to spend their time deep in the weeds. Then for a more Database Read more
-
CloudWorld–Monday
Welcome to a series of … surprise surprise … four posts covering the four days of CloudWorld 2024. One of the challenges of so many sessions at the event is deciding what to go and see, so here’s my tips for anyone like myself with an interest in Database, SQL and APEX Just because all Read more
-
Why I blog – redux
A while back I wrote a post called “Why I blog” which spoke about how interaction with the community is part of the free reward you get from putting your ideas out there on the interwebs. People make comments on what works for them, what doesn’t, how your code might be better etc etc. It’s Read more
-
Safeguard your APEX workspaces and applications
Here’s a quick APEX tip. There are heaps of cool things within APEX to ensure you never lose or accidentally overwrite your applications, such as automatic backups and working copies. But if you share my levels of paranoia 😁when it comes to worrying about the loss of code, data or anything else, here’s a simple Read more
-
23ai – where your vector indexes are stored
The new vector datatype and associated vector indexes are two of the big features in Oracle Database 23ai. The ability to use machine learning models to do quick and efficient semantic searches I feel will really change the concept of searching through data in your database. No more of those embarrassing conversations we used Read more
-
SQL*Loader rows vanish!
Just a quick heads up on the importance of testing thoroughly especially when exploring niche sets of operating conditions with the database (or any software for that matter). Here’s one that came up recently when direct load SQL*Loader was combined with In-Database archiving. First I’ll create an empty DEPT table in my schema. SQL> Read more
-
Quick Tip – Vector Indexes in 23ai
Here’s a quick tip for anyone tinkering with vectors and vector indexes in 23ai. Let’s say you have just created a vector index on your table as per below SQL> create vector index DOC_CHUNKS_VEC_IX on DOC_CHUNKS(piece_embed) 2 organization INMEMORY NEIGHBOR GRAPH 3 distance COSINE 4 with target accuracy 95; Index created. and now you would Read more
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 