Building a Google-style search for your entire application

In this latest session we talked about:
Dealing with date format masks and function based indexes
Installing the sample schemas easily
Improvements to Text indexing in 21c
Building a Google-style search across your applications
Follow me!
blog: connor-mcdonal...
twitter: / connor_mc_d
Subscribe at / connormcdonaldoracle for new tech videos every week
Other social media channels here: linktr.ee/connor
A free Oracle database forever ?! Oh yes indeed!
www.oracle.com...
Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla
#oracle #database

[@aprashant1048]

Thank you Connor! Really like the JSON feature in Search Index

[@asifiqbal5877]

hello, could you please re-write both statements " ctxsys.ctx_dll.create_preference " because it is hidden behind your picture.

[@marcelvanLare]

I like the google search idea. Only I would think it is difficult to manage this in a bigger oltp production database with bulk changes on row by row slowing other users ,locks,producing lots of archivelogs. So it can work nice in small, but have to test it in bigger real production circumstances to see if you can use it there.

[@rdruane]

I've tried creating the search index using the example in oh_fulltext.sql and everything works except for the creating the json search index. The index is created but looking at the ctx_user_index_errors it seems that the procedure is failing with an ora-00904 "RID" : invalid identifier. I'm running this on 19.7, does it need to be run on a later version of Oracle?

[@amitxsaroha]

In this session you looked like most happiest person ever born in the world

[@asifiqbal5877]

hello, anyone can complete the command ctxsys.ctx_dll.create_preference ... ( i am not clear what is the argument ) Thanks a lot.

[@itechpk]

where to_char(dte,'yyyy-mm-dd') >= '2022-09-27' char >= char does this typecast to date ?