Insum - Oracle Specialists, APEX Experts.
We are a custom application development and consulting firm. Our mission is to help clients develop quality solutions built to handle ever-changing needs, on time and on budget.
Services
Consulting, Custom Application Development, Application Maintenance and Enhancement, Oracle-Based ERP Extensions, Cloud Services, Oracle APEX Coaching and Training
---
Insum - Spécialistes Oracle, Experts APEX.
Nous sommes un cabinet de conseil et de développement d'applications personnalisées. Notre mission est d'aider les clients à développer des solutions de qualité conçues pour répondre aux besoins en constante évolution, dans les délais et dans les limites du budget.
Services
Conseil, développement, maintenance et amélioration d'applications, modules d'extension pour ERP (PGI) basés sur Oracle, Services Infonuagiques, Coaching avec APEX et experts d'appoint.
Пікірлер
i haHi, Very Useful. However, I have some issues with it. Does It work with Apex 23.2 or 24.1 ? because I cannot use it for apex 24.1 on OCI and 23.2 for our on-premise. In chrome, It says no access needed. and cannot be activated
I was analyzing your KZread channel ( Insum) Your video content is very nice. Your video does not have good rank tag and the video does not have good SEO. For this reason, your video is not being ranked and viewed. Below we found your channel issue: * Your video doesn't have a good Top Ranking Hashtags, Keywords with the no right Meta tag * Your video doesn't have good SEO & Optimize.
great tip!! thank you Insum Team !
I’ll put the plugin on my blog this coming week. The blog is apexdebug.
hi, this is very nice, thank you all Insum Team. my query is can someone populate a select list or popup lov without the values already exist in IG to prevent duplication? i knew there is a solution 'After Selection' of a value we can prevent user if it is already in IG but what if we do not want to populate those values in a select list query ( Like using NOT IN etc., may be using a page item which contains comma separated values populated on load and add / remove a value when user select or change selection etc.)? i do not know JS, but i knew without JS we can't prevent duplication in IG. if there is a way for this, it will be very helpful for all.
I don’t quite understand what you are asking. Take a look at episode 139. That may be what you need. If not, can you give a specific example? Give me a select statement and tell me the results, and then tell me what you don’t want to see in the results and why.
@@antonnielsen7630 thank you Sir Anton for very quick response. very sorry for any incovenience what i want to. let me explain: i am using Apex 23.1, if i have a master detail page of HR.DEPARTMENTS and HR.EMPLOYEES, interactive grid of HR.EMPLOYEES (Detail) contains a column JOB_ID which is an LOV, the sql quiry is " Select JOB_TITLE d, JOB_ID r from JOBS " ... the restriction is all Employees should have a unique JOB in every Department ... now I want LOV populate values each time on every row when user click on JOB_ID LOV column it should NOT contain the JOB_ID's which are already selected in previous rows in IG ( even IG rows not yet saved in database ), if there is no previous row(s) it should display all values to select. i hope its clear now. with kind regards.
Another great one, thanks! I would like to see you talk about APEX_COLLECTIONS and how awesome they are, also when used with Dynamic Actions, Custom Events and Ajax Callbacks
Great session, So where can we find this plugin?
Nice, thank you Anton
how to enable azure login for ords. can u please guide
this function is not working in the inline of an item in 23.2. please help if any expert sees this message.
Thank you so much, I tried few years ago with oracle 11g, hope to try again, I'll try to replicate what you did here to update my knowledge, if you can share more resources will be great.
great video
Thank you, great session
[06:55] 🤓
I am really interested to watch next episodes. So useful and inspiration.
The entire series is ready and available now! Just register here and see the rest of the series now! www.insum.ca/oracle-forms-to-apex-conversion/
This video solved date related confusion for Apex... Thanks a lot
folks its 2024 its a pain to watch in 720p please do 1080p at least… you made garbage quality for such good tips
Hi, i need your email marwa Thanks
Interesting, thanks.
Ask GPT!
Wow! Really cool Michelle!
hi, i am seeking help to create Faceted Search for date column(s), user can select single date or date range or a month to view report, how it can done in oracle apex? i just created a CR with FS and have 2 Facets, one for Varchar2 type column and another for a Number type column, here i used Range type Facet for Number type columns and it works fine, but can't figure it out how to for Date type columns to enable users as mentioned above. i am searching but still failed to have an example. if there is any guide please share or if not yet please create one to teach us How To. regards
Be sure to watch today!
incredibly beautiful
Useful tips, thanks
voice are not clear.
Hi Anton and Marwa, I went to Linked In and KZread looking for todays Instant Tips but could not find the live video. How do I join each week? I subscribed also.
@bcarlisle2000, don't worry you didn't miss an episode, as there wasn't any last week (May 3). No need to sign up just follow and you'll be sure to get a notification. Thanks for tuning in!
@@Insum Hi Anton, Bill Carlisle again.. I tried to find you again today.. no luck, no notification..😫😀
Thank you Steven! I always learn something each time I watch. I see many times that I need to watch more.. I love to code but I want to get more and more structured.
Could you also do that in the case statement of the SQL to compact it down again in your 3rd example?
Yes! I love overloading and consolidating code!
your tips are, as always, very very helpful! thanks a lot A and M!
Thanks a Bunch buddy. This video came to my rescue ❤. God Bless keep on sharing 😊
Glad it helped! Thanks for following :)
Thanks! This was great, helped me loads! Unfortunately after having my app running in english, portuguese and french i found something dissapointing in the way that Repository works. Let's say that i edit a long message i have in a Help section (due to a minor error in the original lang), after seeding again i will loose the previous translation in PT and FR. The only way to counter this would be to use Text Messages instead of the Repository but some fields like Help section only accepts HTML so i can't invoke the APEX_LANG API. Have you felt this pain?
Excellent tip, this bothers us for a long time! Thanks to you guys!
tks, but which Chat GPT model works in this moment? because davinci doesn't works.
What is with the chattery chat 🤷♀️ Have a nice day !
it's simply amazing presentation!!!
Marwa always give us Informative tips.
we had an earthquake last weak too I don't think Marwa felt it 😅 I freaked out and got out of the house 😂
Great tip! Thanks for sharing it.
Which version of APEX has this report ?
It goes way back...Maybe even HTMLDB 5. Look under SQL Workshop > Utilities > Object Reports.
great
FOUND MISSING FK ON PCOS TO PRECIENT TABLE
how to get data from interactive grid select list column into page item.
Best example of making a plugin asap !! thanks
'Promosm'
Great subject and tips thank you Anton for hosting my sister Marwa you both are brilliant !
Great job sis I'm proud of you ! - Marwa's brother "Nadhem" Thank you Anton for inviting her.
This is really great!
Hi minus and exactphrase is not working. Cab you please help me how can i leverage that