Questions

Hi Tom,If there is any duplications of records in a table, we know how to eliminate the duplicate rows using rowid.But is there any possibility to delete the duplicate records in a table without using rowid and rownum.my friend who is working in Oracle for ar...

Hello,I work as a dba and get requests from developers to create tables which we often review and sometimes change for better design and/or implementation.One of the developers recently sent a request to create a table such as the following ;table_name:t1_rela...

Long time SQL user of many flavors but brand new to PL/SQL and struggling to learn the "Oracle way". I've seen MANY examples of using variables in queries online and in documentation, but I've been unsuccessful finding a sample of what I want to do and how to...

Hi team,I have a database which is in no archivelog mode and NO Backup like rman and cold backup are available. Only logical Backup (export schema) is available. And suppose one datafile is corrupted or dropped like rm then how can i restore and recover the d...

Hi folks,I would love to have the JSON from the following REST request:<code>https://sgx.geodatenzentrum.de/geoserver/vg250-ew/wfs?service=wfs&version=2.0.0&request=GetFeature&typenames=vg250-ew:vg250_sta&outputFormat=json&srsName=urn:ogc:def:crs:EPSG::4326</c...

I'm using Oracle 19.28, oracles 3.3.0 and python 3.9.20.What are the rules for using bind variables (either positional or named) when calling a stored procedure using oracles ?Additionally where can I find a complete list of DPY error codes from oracles ?...

Hi Dear Experts, I want to create a SQL PLAN baseline for one of the My system query in a two-node RAC 19.21. With user SYS and inside a PDB with the following commands<code>var v_num number; exec :v_num:=dbms_spm.load_plans_from_cursor_cache(sql_id => '0b3......

Hi I am using Datapump to export dump file from a database and while exporting the dumpfile, I am splitting that dumpfile into multiple files. Now I want to transfer those files to another server using DBMS_FILE_TRANSFER.PUT_FILE. I know I can explicitly menti...

how to download a free oracle magazine in pdf about getting latest oracle database and it's technology relevant information as like MSDN of microsoft....

Which PL/SQL package is primarily used for interacting with Generative AI services in Oracle Database 23ai?DBMS_AI or DBMS_ML or DBMS_VECTOR_CHAIN or DBMS_GENAI?...

Hello,I am looking for the OpenAPI 3.0 of the GoldenGate API 21.3We only found the Swagger 2.0 file from this URL : https://docs.oracle.com/en/middleware/goldengate/core/21.3/oggra/swagger.jsonThank you for your help....

Hi,Does Oracle have any plans to support RS256 in Apex ? Thanks https://apexapps.oracle.com/pls/apex/r/apex_pm/ideas/details?idea=FR-4418&session=105003035734261...

HelloIs there any method to get the MIME type of BLOB data file using plsql?Ex for PDF - application/pdffor xlsm - application/octet-stream etcFor reference you can take fnd_lobs table in Oracle Applications....

Hi,The documentation https://docs.oracle.com/en/database/oracle/oracle-database/19/ostmg/asm-filegroups.html#GUID-BE9083C8-A5DF-48CD-BB32-C8A6FCDA3E7Bsay about redundancy PARITY: "not supported on data files".But what if i have ReadOnly tablespace? I'd like to...

Hi All,Can the Deletes be used in place of SELECT in CTE ?(below code snippet is a sample)<code>--selectwith cte_sample as (select date from example)SELECT * from calendar_extract where date in (select date from cte_sample);--deletewith cte_sample as (select d...

How does Oracle's flashback technology utilize flashback logs to enable point-in-time recovery, and what limitations should DBAs be aware of?...

Tried all the steps nothing is helping : Gave all grants :Used this as an Admin : select * from dba_credentials; grant write on directory data_pump_dir to X_GC_DW; grant read on directory data_pump_dir to X_GC_DW ; SELECT * FROM dba_tab_privs WHERE table_n...

This is my example data:<code>CREATE TABLE xml_test ( xml_col XMLTYPE NOT NULL);/* */INSERT INTO xml_test VALUES (XMLTYPE('<ns1:SomeRootNode xmlns="http://www.exampleurl.com" xmlns:ns1="http://www.someotherurl.com"> <ns1:SomeParentNode> <ns1:SomeRepeati...

After updating to v25.x.x of the Oracle SQL Developer extension for VS Code, I noticed that SET DEFINE OFF only works when I run the script (F5) in the first line. In previous versions, SET DEFINE OFF worked regardless of where the script was executed.Is this ...

Hello Community, I have 5+ yrs of experience. I am trying for a job change. While attending interviews i can able to answer all theoretical questions and queries but i couldnt able to answer senario based questions. How can i level up my preperation as i am on...