
One Oracle Developer
201 FOLLOWERS
Covers code snippets, tips and tricks and thoughts for Oracle developers, SQL, PL/SQL, APEX, clean code, certifications.
One Oracle Developer
1w ago
T
There is a new exam available at Oracle, the Oracle AI Vector Search Professional (1Z0-184-25). And since the certification is not listed under the Cloud certifications, it wont expire.
"The Oracle AI Vector Search Professional Certification is designed for Oracle DBAs, AI engineers, and cloud developers to unlock the potential of Oracle Database 23ai to build AI-driven applications. The target candidate for this certification should have basic familiarity in Python and AI/ML concepts. This certification bridges the gap between traditional database management and cutting-edge AI technologies ..read more
One Oracle Developer
1M ago
A
A year ago I have shared a tip how to use the same mechanism for closing modal dialogs. Today, I would like to share few more tips about levaraging the Global page.
When you have a button on page and the action behind is a bit slow or if you have users who are constantly double clicking on everything, you might want to disable clicked button. You can easily fix this with a simple dynamic action. But instead of repeating this DA on each button, you can define it on the Global page. The trick is to use the jQuery selector and CSS class on each of these buttons.
So go to your Global page.
Cre ..read more
One Oracle Developer
3M ago
T
Today, I will show you how to easily check if your authorization schemes set on pages match the schemes set in the navigation.
In my custom navigation (including the multicolumn navigation), I don't have to set it in two places (which is never a good idea). My navigation gets the schemes from the pages. But the default APEX navigation is not like that.
Fortunately, if you combine few APEX views, you can find out:
SELECT
p.application_id,
e.list_name,
p.page_id,
p.page_name,
--p.page_alias,
--p.page_group,
--p.page_mode,
p.authorization_scheme AS auth_scheme_ ..read more
One Oracle Developer
3M ago
I
I spent the past few days at the HrOUG conference in Rovinj, on the Red Island. I was there for the first time.
The location was superb, but difficult to get to, at least from Prague. No direct flights, no trains, 9 hours by car...
The hotel was ok, I expected it would be a bit outdated and it was not. But I was not expecting a noise till 2am. If you are not an old fart who goes to bed at 10pm like me, you probably won't bother.
The food was excellent. I don't think this can be improved.
The sessions. With the 5 tracks and one dedicated to Oracle APEX and the other one to Oracle AI, there wa ..read more
One Oracle Developer
4M ago
I
I was going to write about the brand new and hot Oracle AI feature, the prebuilt OCI Generative AI agent with RAG, which I saw last week at local Oracle event at Prague. You basically get a pretrained AI agent, throw at him your files and he will be answering your questions with knowledge gained from your files.
The plan was to spend some time during the weekend and play with it, but both my cloud accounts are at Frankfurt. Despite the claims of the Oracle support, you have to be in Chicago region. It is not available in other regions yet. I don't want to create another free OCI account and ..read more
One Oracle Developer
4M ago
T
Typically you have some constants in packages. And sooner or later you need to use these constants in SQL statements outside of the package, like in a view. Sadly even the latest Oracle 23ai wont help you with this. The solution is to create a function for each constant, which can be very tedious if you have many constants.
I have created a generator to automate this, but here is a different approach. We have can utilize the USER_SOURCE view to get the constant value and the USER_IDENTIFIERS view to localize constants in the package. With this approach you can also expose constants from the ..read more
One Oracle Developer
6M ago
C
Common sense says you need more than a paycheck to be happy, but happy work won't more likely pay your bills. Ikigai is about finding a balance between what you love, what you are good at, what the world needs, and what you can be paid for.
You might enjoy the rat race more with more money, but at the end of the day, you will still feel empty. If you don't enjoy what you do, you are missing a lot. If you are happy in your job and you think you can do this for the rest of your life (and not just till retirement, that is the key difference), congrats! You might have found your Ikigai. If not ..read more
One Oracle Developer
6M ago
L
Let's face it. As an Oracle APEX developer you are a full-stack developer whenever you like it or not. And if you are one, you know what I am talking about. If not, brace yourself.
As APEX developer you have to know APEX. But you also have to know SQL and PL/SQL. It is not realistic to build real/complex app without that. If you are into customizing the look and feel (UI and UX) you will have to know HTML5 and CSS (and design, color theory, typography...) and you will have to know a lot about JavaScript.
You also have to know the database design (including a data modeller tool), architectur ..read more
One Oracle Developer
7M ago
I
I have been designing a small app where you can sync data in tables based on some web service calls. I wanted to give the users a flexible and simple option to schedule refresh of selected tables at specific time. So I have created a page where they can create, manage and test schedules. On the main page they have a list of tables and each schedule as a column with checkbox so they can easily change and see when are which tables synced.
The issue is with the schedule intervals (the schedule definition). At first I have added the [?] button with a link to the documentation. But I have realiz ..read more
One Oracle Developer
7M ago
I
I like my certifications fresh. You can brag that you are one of the first ones who took the exam, you can help to promote and even raise the awareness that the certification exists. And no one can accuse you of cheating.
Here is my mini review of the 1z0-171 exam:
Most of the questions are pick 2 or 3 from 5 or 6 options. Much harder to do than on OCI foundations exams where you are picking 1 from 4. Half of the questions are easy to understand, easy to answer. One third is much harder and it will make you sweat. The rest would go to the very hard category and I would say that I have face ..read more