Questions

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 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 ...

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...

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...

I'm using a UDT with dataset inside there as a table and i want to use that UDT on Merge statement. When using that UDT, i put that UDT inside "ON (" as following: "... ON (SELECT * FROM TABLE (UDT)) ..." then, how can i to use that UDT inside INSERT statment ...

Hi Tom,first at all, thanks for all your support. I wish a blessed christmas time for you, your team and families.I´m looking forward for the best practise of a cursor to fetch just one (or a few) row(s) on my own sorting and lock them. Without locking the who...

We have a production DB that is used for reporting is been attempted to clone with NetApp Snapmirror technology. The current clone is done with old method placing the tablespaces of PROD DB in backup mode and then copying the files using OS “cp” tool to the d...

I'm using external tables everyday to load csv files but I'm having great difficulty loading my first FIXED WIDTH file. I've tried several different access parameter variations and the CREATE TABLE command compiles without error but when I select the table, I ...

I am trying to create an sql script that creates a user and if a password is supplied as a parameter to use it and if no parameter is passed have the sql prompt for the password.This is what i tried but I am obviously a bit off since it asks for the Value of &...

<code>Team,Good Monday Morning !!!!!!we are facing difficulty in sending mail through oracle code, for the data being retrieved from one or more data base tables .(Issue arises when the data is huge)The records fetched from the query shall be in the form of H...

Oracle documents say Log buffer is normally small compared with the total SGA size, its key ratio is the space request ratio: redo log space requests / redo entries.Could you tell me what is the key ratio we are looking when adjust log buffer in initsid ora fi...

Hello experts,I am in 12.2, multi-tenant architecture, no RMAN catalog, auto backup control file.I have a problem to restore with RMAN a deleted tablespace.I create it and I made a complete backup of my container with the PDB and the tbs.<code>SQL> CREATE TABL...

Hello,I've been struggling with "strange" behavior with handling "extreme " timestamp values.Our applications in .NET execute stored procedures with timestamp parameter and in some cases pass "31/12/9999 23:59:59.9999999" - it is value of Datetime.MaxValue fun...

Hi TomGreetingsWe had very high critical Application(with zero downtime) running in 4 Node RAC Environment with same HA Configuration. We are planning to perform defragmentation(Index) with minimal downtime.We are planning the following steps1) Disable Apply a...