Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered Report

Chris SaxonProblem with dots ('.') in domain index
Dear team,I hope you are all doing good!I wanted to ask for some hints to fix the following problem:We have a huge dataset (>60 mio) of items. Each item has an item number. The item number has the datatype varchar2(50). The format of the item number vary from ...
Chris SaxonExact SQL Text match in gv$sql
Hi Chris, Connor,I have an application SQL written in below format <code>select /* Q_ORDERS_001 */ order_id from orders;</code>However, when I queried gv$sql to see the sql information, I couldn't find the excat match of the sql.In gv$sql I got an entry with ...
Chris SaxonQuery rewrites on MVIEW using JSON DATA
Team:This below testcase was run on Oracle 19.9 database.q1) why the online stats gathering feature doesn't kick in post the direct path load on "twitter_data" table?q2) could you please help us to understand though we have Mview inplace, why the optimizer is ...
Sergiusz Wolickiaccent/case insensitive search
Hello TOM and Happy New Year!We have a table with a VARCHAR2(200) column that stores `names` with European accents: Valérie, Véronique, and so on.We would like to perform a CI/AI (case-insensitive, accent-insensitive search) on those values, i.e. people search...
Chris SaxonMaterialized View from two tables only inserts but does not update
Hello...I am new to using materialized views (MV) in Oracle, and I am having problems making this one work. I have two tables, SWO_LINE and SWLN_ADD where I insert and update records.I have created MV Logs for both tables as seen below:<code>CREATE MATERIALIZE...