Questions

I am using version 23.1.1 and when I start up the application, it just hangs. I have no idea what to look at to even begin to diagnose the problem. ...

Dear Experts, Social Sign-in with Microsoft Azure/Office 365 in Oracle APEX applications is working well. I used this How-To: https://tm-apex.hashnode.dev/implementing-social-sign-in-with-microsoft-azureoffice-365-in-apexWhen I use the substitution variable in...

<code>create table add_column_default ( id number )/insert into add_column_default ( id ) values ( 0 )/alter table add_column_default add col1 number default 5/insert into add_column_default ( id, col1 ) values ( 11, null )/select * from add_column_default o...

Our application connects to the database via the Oracle Instant Client using the scan address on RAC, we therefore end up connecting to an arbitrary instance. We would ideally like to be able to query the alert log directly from our application, there is a V$...

Hello Sir,We're using Oracle Database 19C Enterprise edition.We're getting a XML tag in Varchar2 format. Then we're using XMLTYPE to convert that to XML. However, incase when there's special character in the XML tag it's giving a unknown special character in t...

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