Questions

We have a requirement where we are generating .csv file from DB and placed it to a DB directory. We want to zip these .csv files so that size can be optimised. Could you please suggest a way to achieve it by using PL/SQL....

<code>-- Settingsselect banner from v$version;--Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Freeselect * from v$nls_parameters where parameter in ('NLS_NUMERIC_CHARACTERS','NLS_TERRITORY','NLS_LANGUAGE');-- NLS_LANGUAGE ...

What are the recommended BIG-IP F5 settings for routing HTTP traffic to ORDS 24.4 without SSL in an Oracle EBS-integrated environment?...

Is there a commit size parameter for datapump import utility in the future? Currently there is none. I see direct path insert and parallel process are there and if so will adding commit size parameter help in faster data loading....

Hello and thank you for your response.Sorry I could not provide a live example SQL.I have an application running in JBoss connecting to a database Reporting_DB and executes SQLs there.The SQLs actually would access views in the Reporting_DB.The views are acces...

Hello AllI have created a Materialized view using the following code<code>CREATE MATERIALIZED VIEW "APPS"."XXBST_UNPACK_PENDING_MV" ("CUST_ACCOUNT_ID", "CUSTOMER_NAME", "SUPPLIER_ID", "SUPPLIER_NAME", "SHIPMENT_ID", "SHIPMENT_NUMBER", "UNPACK_DATE", "DAYS_IN_U...

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

Hi Sir,I'm trying to copy the Oracle Label Security information from one database and apply it to another one.I tried to use expdp/impdp and dbms_metadata.get_ddl, but I didn't have success using them.Is there a special package or tool to get this work done?Th...

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

Hello experts,I have a UNIQUE constraint on (col1, col2) for a table. But, due to new functionality, I need a conditional unique constraint based on col 3.So something like this:if col3 = 'Val1': UNIQUE constraint on (col1, col2)else: UNIQUE constraint on ...

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