With 23c/23ai , find ANY data in ANY table easily!

preview_player
Показать описание
In 23c/23ai , it now take just a few lines of code to enable a Google-like search across your entire database!

Follow me!

Subscribe for new tech videos every week

Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla

#sql #database
Рекомендации по теме
Комментарии
Автор

What a nice feature! I guess there are scheduler jobs associated with this facility to update index in background.

Elfcheg
Автор

Is the json data really constructed from the index.. I.e. the fülltest index does not only contain reverse tokens but full data (I.e. indexsize is more that data size?) or does it just transparently query the rows to construct a virtual complete result document?

berndeckenfels