Hi Tom and Team, I am looking to remove the invalid records before applying PK<code>create table OLD_ABC( PRODUCT, CLASS, SEASON_KEY, DATE, PRICE)KEY -- (PRODUCT, CLASS, SEASON_KEY, DATE)TABLE records -- Ex. ABC , 121 , S ,1-JAN-21, 15 PQR , 1

I need to give access to other user on current DB_LINK, can you provide command ?Current Link: sittestGrant to User: Z9XBIQ1_DWRegardsChaudhry

Hello all,Greetings of the new year!Goal - generate an output which can be directly used for pasting hierarchical data into a flat fileLink to liveSQL with sample data and scripts - https://livesql.oracle.com/apex/livesql/s/mw9olr17o7dir21jysn5jni1uExpected ou

Hello All,The problem I raised uses a scenario from one of the quizzes played recently on Devgym.I try to use DBMS_MVIEW.EXPLAIN_REWRITE for a materialized view in LiveSQLand for some reason, I encounter an error for both the table and the array version.- For

Hi Tom,We are supporting a Siebel application having Oracle 11g as backed. Last month we upgraded database to 19C and after that we are facing performance issues on daily basis. When we checked DB reports like AWR and ASH, I have below observations:a) In AWR r