Skip to main content

Posts

Showing posts from July, 2024

Leverage AI for DBMS_SCHEDULER intervals

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 realized that nobody from the business will be willing to read that and not everyone will be able to actually create the repeat interval string. So I thought, wouldn't it be nice if you just describe the interval in english and don't care about the technical part at all? Screens for better imagination, prompt and response: This is probably the most simple use case for AI you ca...

Oracle Database 23ai SQL Associate, 1Z0-171 exam review

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 faced several questions where I strongly disagreed with the answers (it is when you are suppose to pick 2 from 6, but you know that 3 are possible or they ask for 3 and you know that only 2 are possible). But based on other legacy exams the percentage of these questions is not bad. On one question I have to guess 3 options from 6 based on non existing exhibit image. I really liked the questio...

Copy cell value from IG, revisited

H How to copy cell value from Interactive Grid? I wrote about this few years back in this article . Since that I have been warned by several people that it does not work on some occasions. Non editable grid, Redwood theme, read only cell with link... Many issues. Thanks to Matan from Israel and his ChatGPT friend here is a better solution: document.addEventListener('copy', (event) => { const allowed = 'a-GV-cell'; const active_el = document.activeElement; if (active_el.closest(`.${allowed.replace(/\s+/g, '.')}`)) { const selected = window.getSelection().toString() || active_el.innerText; event.clipboardData.setData('text/plain', selected); event.preventDefault(); } }); But we get the whole row (instead of the selected cell) when copy pasting to Outlook (or any rich text editor). So after more testing and tweaking, we came up with this final solution: document.addEventListener('copy', (...