Questions

I have two questions both referring to the documentation in Oracle 19c SQL Language Reference PARALLEL hint "For a statement-level PARALLEL hint" section.https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Comments.html#GUID-D25225CE-2DCE-4D9F-...

1) I created Employee master FORM from emp table2) In employee form deptno is the select list and I put button for new department add. It will call dept page form which has property chained = false3) After adding new dept control goes back to employee form but...

Hi Tom – My task: move several dozen text file imports from SQLLDR (on AIX) into callable PL/SQL procedures. The text files are static in structure with daily refreshes of the contents. The contents are loaded into individual tables in our 19c EE database.Th...

Is there a way to create a index for a xpath that is including a xpath function?Please consider that xmltype index creation fails at oracle livesql....

Hi Ask-Tom-team,What is the recommended way for exporting a table that contains a CLOB column to a SQL script? The standard feature of the SQL Developer only exports all columns that are not CLOBs. I want to export the table to a SQL script for including it in...

Good Morning Tom.I need your expertise in this regard. I got a table which contains millions or records. I want to update and commit every time for so many records ( say 10,000 records). I dont want to do in one stroke as I may end up in Rollback segment i...

I have recently inherited a migration suite that takes a long time to run, so I am looking at the various long running SQL commands to try and improve it. One areas of issue is some data validation that also does updates. Each validation is scanning a table of...

Hi Tom,Hope you are doing good !!!I am very glad to writing this post to get valuable information from you. We were in situation to join multiple remote tables joining in order to get expected data into our schema but its taking longer execution time (i.e. 5k ...

Hello, I'm not a native speaker so I hope to explain myself correctly,I have a table three with the headers and a body table with the data, and I need get the average by every level, there are 5 levels but could modify in the future, but there are some conditi...

Hello Sir,Need one suggestion after upgrade oracle database from 12c to 19c which are the initialization parameter need to change for better performance.kindly help to understand this.One more suggestion required is there any precheck we can follow for success...

Hi Tom,I'm looking at a client application which retrieves several columns including ROWID, and later uses ROWID to identify rows it needs to update:update some_table t set col1=value1where t.rowid = :selected_rowidIs it safe to do so?As the table is being mod...

I have one more requirement where I need to change one particular user's password belongs to an application which is hosted outside of our network.External application team provided information about REST API that need to used to search user and change passwor...

I have 2 tables with 2 columns each; first column is VARCHAR2 & the second is LONG RAW - to store images - for both tables.I am trying to create 2 tables (for trial purposes) based on these tables using the following statement:-CREATE TABLE <name>ASSELECT * FR...

Hello!As it's said https://docs.oracle.com/en/database/oracle/oracle-database/18/xeinl/oracle-database-xe-user-data-limitations.html:"user data in an Oracle Database XE database cannot exceed 12 gigabytes".Would You explain how to get exactly that user data si...

HiThe Oracle DB version I am working on is : Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionIts a RAC with 2 instances.This is about a query which runs quickly (under 15s) under instance #1 but takes between 10-11 mins when it runs...

Hi Team,When I am trying to load an UTF8 characterset datafile using sqlldr, it fails with Multibyte character error.Steps to reproduce the issue:1. Create table.create table LoaderTest(rec_no number,rec_id_no nvarchar2(30),column1 varchar2(2000 char),column2...

Hi, we have run into performance issues after upgrading to Oracle 19c (19.14). For some SQL query’s the optimizer will no longer create execution plans similar to them in Oracle 11g (11.2.0.4) resulting in extreme slow performance (up to a factor 1000 times).T...

<code>declare type t1 is record ( f1 number ); type t2 is record ( f1 number ); v1 t1; v2 t2; procedure q(p1 in t1) is begin null; end q; procedure p(p1 in t1, p2 in t2) is procedure q(p2 in t2) is begin null; end ...

I have read several books which have repeatedly mentioned creating indexes on foreign keys. I know one advantage is that it eliminates table-level locks and, I have seen the benefit since I have encountered a similar problem. However, I would like to know if y...

Hello Tom,I have one column INTERVAL_TIME with datatype as TIMESTAMP(0) and stores data in 15 mins interval time.Since there was DST on 13 March 2016 , the interval was store at 1:45 AM and next interval at 3:00 AM.But when i am applying to_char on the column ...