Skip to Main Content

Questions

QuestionUpdatedAsked

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 ago11 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 ago12 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 ago11 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 ago11 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 ago6.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 ago19.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 ago10 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 ago2.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 ago2.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 ago5 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 ago16.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 ago5.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 ago21.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 ago1.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 ago1.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 ago5.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 ago3 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 ago12 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 ago22 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 ago5.4 years ago