In this episode, Mike Hichwa, co-creator of Oracle APEX demonstrates a tip you can use in virtually any version of APEX. In his demo app, Mike wants to easily find developers for his Project. He adds a select list that shows the best matches at the top of a long list.
Here is the code Snippet Mike used in his demo
with suggested_developers as (select name, id, count(*) as score from(select
dd.name,
dd.id,
t.column_value as tag
from demo_developers dd,
apex_string.split(dd.tags, ',') t
where t.column_value in (select
t.column_value as tag
from demo_projects dp,
apex_string.split(dp.tags, ',') t
where dp.id = 1))group by name, id
order by 3 desc, 1fetch first 3 rows only
)
See the full episode
View Past Episodes
Full episode list on YouTube here.
Past Episodes
APEX Instant Tips #162: About Display Only Items in Oracle APEX
In this week's tip, any time you set a value in the browser, a user could...
Read moreAPEX Instant Tips #161: More about hashing than you could possibly want to know…but you should.
Marwa and Anton take you through hashing and checksums. Maybe more than you could possibly want...
Read moreAPEX Instant Tips #160: APEX utilities you may never need, but if you do, they’re good to know.
Anton and Marwa show you the utilities you can find in APEX Object Reports, and there...
Read moreAPEX Instant Tips #167: APEX sessions, APEX engine requests – Behind the scenes
Anton and Marwa discuss the underpinnings of the APEX engine, including ORDS, and demonstrate using trace...
Read moreAPEX Instant Tips #166: Using the browser network inspector for APEX environment insights
Have you ever seen this error when you click save? "Error: SyntaxError: Unexpected token DOCTYPE... is not...
Read moreAPEX Instant Tips #165: You Must Markdown This Tip
How to make your optional label templates start in column 1 and how to publish your...
Read moreAPEX Instant Tips #164: Three Tips, Workarounds, Hacks…you be the judge.
Tips on how to resize regions, show warnings on dynamic actions, and keep your region "page...
Read moreAPEX Instant Tips #163: APEX_DEBUG tips and quirks
This week, Anton and Marwa cover APEX_DEBUG.ENTER, .INFO, .MESSAGE, .WARN, .ERROR and more...Happy New Year!
Read moreAPEX Instant Tips #162: About Display Only Items in Oracle APEX
In this week's tip, any time you set a value in the browser, a user could...
Read moreAPEX Instant Tips #161: More about hashing than you could possibly want to know…but you should.
Marwa and Anton take you through hashing and checksums. Maybe more than you could possibly want...
Read moreAPEX Instant Tips #160: APEX utilities you may never need, but if you do, they’re good to know.
Anton and Marwa show you the utilities you can find in APEX Object Reports, and there...
Read moreAPEX Instant Tips #167: APEX sessions, APEX engine requests – Behind the scenes
Anton and Marwa discuss the underpinnings of the APEX engine, including ORDS, and demonstrate using trace...
Read moreAPEX Instant Tips #166: Using the browser network inspector for APEX environment insights
Have you ever seen this error when you click save? "Error: SyntaxError: Unexpected token DOCTYPE... is not...
Read moreAPEX Instant Tips #165: You Must Markdown This Tip
How to make your optional label templates start in column 1 and how to publish your...
Read more