Questions

Hello Tom,I have a live table (Investor) with customers records and another table (Invdatew) has the same records but have one extra column for date,. After each end of day I use dbms_job to insert the the exact data from live table to the other one plus sysda...

Hello,Could you please clarify the meaning of the view V$RESERVED_WORDS and especially its contents?At first glance, the documentation has a clear explanation. The view contains reserved words, and columns RESERVED, RES_TYPE, RES_ATTR, and RES_SEMI describe, f...

We have seen in many situations in our environment where a SQL was running badly but the plan for the query has not changed. When we gather stats for the associated table.we see that same query performs significantly better. However there is no change in PHV o...

Hello, TomWe have been facing the slow rollback after killing job of huge transaction, then we discovered several ways to speed up the rollback process.So one possibility is altering hidden parameter "_cleanup_rollback_entries" from default value (100) to be 4...

Hi,<code>CREATE TYPE phone_typ AS OBJECT ( country_code VARCHAR2(2), area_code VARCHAR2(3), ph_number VARCHAR2(7));/CREATE TYPE phone_varray_typ AS VARRAY(5) OF phone_typ;/CREATE TABLE dept_phone_list ( dept_no NUMBER(5), phone_list ph...

We would like to encrypt data at rest in an oracle database column (in one specific database table only) using an encryption key held externally in a vault.Does Oracle provide standard interfaces to make API calls ?The encryption key should not persist in the ...

Hi,I have procedure via database link, and getting this errorORA-02064: distributed operation not supportedThis is because need to apply pragma autonomous_transaction. But is there any other way? some of the procedure we need to reuse, and we only need to per...

Dear Experts,Need your guidance/suggestions to resolve this issue:Part of oracle advance queueing implementation, we've to dequeue the message as soon as it has been enqueued into the queue. This should happen immediately without any manual intervention/schedu...

Hi,I have a query which i am trying to load the data using 2 options:1. Materialized View Refresh with Non-Atomic Refresh2. Insert into Select Materialized View Refresh: When i try to Complete refresh a Materialized View in 12c Database residing on Exadata, Th...

I want to get difference between two dates say(10-FEB-2000 - 02-JAN-1999)and the result has to be displayed in following format1 year, 1 month, 8 days ...

Hi,I am carrying out an update on dept table with update query as - "update dept set dname = initcap(dname) where deptno=20;"As, I have not committed, row lock will be placed on the row. I want to find out the rowid of dept table locked from V$LOCK. Currently,...

Good day,I want to backup my Snippets but cannot find the file to back it up as I cannot locate the XML file with my Snippets therein. I went to system23.1.1.345.2114 and in there I went to o.sqldeveloper.snippet and this folder is empty despite me setting "So...

Hi Gurus,I have a schema as described in the link https://livesql.oracle.com/ords/livesql/s/ct0zdah8slxq66h8fnpfhwdby.<code>drop table t;create table t( instance number , id_sup number , id number , srt number , v01 number , v02 number , v03 number ...

Hi Senior, My database is 12C PLSQL. Is it possible to alter table and add IDENTITY for primary key, if the data in the table is beyond <b>200Crore</b> or <b>2Billion</b> data. As I am concerned about database crashing or Cache overflow.Please guide ...

We have a context index that is SYNCing every 6 seconds. Here is the DDL for the index: CREATE INDEX "SSS"."QUOTE_NUMBER_CONTEXT" ON "SSS"."QUOTE" ("NUMBER_") INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS ('SYNC (EVERY "SYSDATE+1/14400")');This was working p...

Hello,Mastering Oracle PL/SQL book has been released 21 years ago with Connor McDonald as one of the author:https://github.com/Apress/mastering-oracle-pl-sqlI would like to know what you would modify if you would update the book for Oracle 19c:- any topic to b...

Hi,Recently while preparing to run the Release Upgrade for 19.24 I was doing a cold back of my ORACLE_HOME and I noticed that I had a ton of old .log, .trc, and .trm files. I deleted old files in the trace directory, audit directory, and some of the log direc...

Hi Tom & Team,we have ORACLE Database 19C and it is editionable.ALPHA/BETA/ORA$BASEwe have created our tables with XXX_E (non editionable) and created views(editionable) on top of it.Active edition is ALPHA.in BETA(Inactive edition), when we increase column le...

If I only wanted to do multi-master replication of just a few tables (<5) between two Oracle databases in Oracle 19c here in 2023, without having to pay for the Golden Gate license, what are my options?I want something like the "Advanced Replication" feature f...

Hi Tom, I have sql statement with pdf book url attribute. I need virtual column till me the url is valid or not found. So I need page http status code either java function in oracle apex, or sql query.example: select title_no, title_name, pub_date, 'https://li...