Skip to main content

Posts

Showing posts from December, 2023

Talking to Oracle Database, this time in plain Slovenian

Talking to Oracle Database in Slovenian In my previous blog post, Talking to Oracle Database in plain English I am discussing how to query Oracle Database using natural language queries to retrieve data from an Oracle database. Exploring SELECT AI Figure 1: Select AI From my quick exploration, I can conclude that AI has definitely entered databases and can be applied in very different scenarios. For example, using SELECT AI in chat application where data can be retrieved and presented from Oracle Database by applying natural language query. But that was in plain English. But what about if my primary natural language isn't English. What if your (and, for this matter also mine) isn't English. What if it is Slovenian? Would SELECT AI still work? Revisiting English Examples in Slovenian Let's examine the very same examples that I used in my previous blog post. Let's talk now ... po slovensko Enough said. Let's try the simplest query of all and let...

Talking to Oracle Database in plain English

My SQL beginnings It was approximately 35 years ago (gosh, that long!?) when I first encountered SQL—Structured Query Language, for those who might not be 100% sure what I am talking about. It happened during labs at faculty when we visited IBM's training center in Radovljica, Slovenia, to learn and experiment with this (at least for me) new programming language. They called it a 4th generation language. With its roots in Boolean algebra and simple structure, we were told that it was almost like natural language (English, of course—who would have thought one day you would use Slovenian to query databases?). With all those SELECTs, FROMs, WHEREs, GROUP BYs, HAVINGs, ORDER BYs, etc., it actually sounded really cool and easy. My Select AI beginnings Fast forward to today, the other day I finally found some time to explore something different from my usual daily work. What caught my attention was one of the latest Oracle blogs: Introducing Select AI - Natural Language to SQL ...