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-... | 6 hours ago | 11 days ago |
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... | 7 hours ago | 12 days ago |
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... | 24 hours ago | 11 days ago |
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.... | 24 hours ago | 11 days ago |
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... | 24 hours ago | 6.5 years ago |
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... | 24 hours ago | 19.5 years ago |
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... | 24 hours ago | 10 months ago |
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 ... | 24 hours ago | 2.3 years ago |
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... | 24 hours ago | 2.9 years ago |
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... | 30 hours ago | 5 months ago |
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... | 30 hours ago | 16.4 years ago |
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... | 30 hours ago | 5.2 years ago |
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... | 30 hours ago | 21.8 years ago |
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... | 31 hours ago | 1.9 years ago |
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... | 31 hours ago | 1.8 years ago |
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... | 31 hours ago | 5.6 years ago |
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... | 31 hours ago | 3 weeks ago |
<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 ... | 31 hours ago | 12 days ago |
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... | 31 hours ago | 22 years ago |
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 ... | 5 days ago | 5.4 years ago |