Ask The Oracle Mentors

Recently Answered

	Problem 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 ...
	Exact 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 ...
	Query 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 ...
	accent/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...
	Materialized 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...