Questions

hi folks,I am very happy about the new enum domains in PL/SQL. They are very useful and can make the code much more maintainable.But I struggled over a problem. When I create an enum domain like <code>create domain MY_TEST_ENUM as enum ( text1 = 'text1', tex...

With Always Free, there is no support. How do I get DBMS_CRYPTO grant? I tried using STANDARD_HASH, but it says STANDARD_HASH must be declared. So is there a way to get this access preferably to DBMS_CRYPTO? If not is there an alternative?...

Refer to object-relational-developers-guide / Column Object Storage in Relational Tables If “The null indicators for an object and its embedded object attributes occupy one bit each. Thus, an object with n embedded object attributes (including objects at all ...

Hi Team,From performance perspective, which is a better filter IN or NOT IN?...

I've installed Oracle Secure Backup using osbws_install.jar on a couple of hosts and it works fine on all of them (i.e. I can list, add and delete credentials in the wallet without being prompted for password). But on one particular host, after installing, whe...

I need to report the database sizing to our management.Following are the questions:1) Total space allocated and used for each Database instance (We have 14 each for 3 applications) 2) How is the growth pattern over the last few years. Year to Year change. My a...

Hi Tom, good morningMy question is very clear and generic, and very important for me due to a current discussión in my team:We have a database in the followint situation, the worst scenario, I guess:- standalone (no RAC, no Dataguard)- Only one disk with all i...

Hi Tom,Suppose I am having following SQL queryUPDATE TB38OSET G000KE =(SELECT TB39G.A6000D FROM TB39G WHERE TB39G.A0020C = TB38O.A020KF AND TB39G.A0090C = TB38O.A090KF AND TB39G.A1010Y = TB38O.B010KF AND TB39G.A6000Y = TB38O.G000KF AND TB39G.A0230Z = TB38O.A23...

Hi.I'm using Oracle Analytic Views (from 19c) as defined here: https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analytic-views.htmlI can create measures with simple aggregations (eg: SUM, COUNT, MIN), but I can't create a measure th...

Hello,Is there any way to exclude a list of tables while doing DBMS_STATS.GATHER_SCHEMA_STATS?DBMS_STATS.LOCK_TABLE_STATS doesn't answer my need exactly.Best regards,Amine...

I have been working on a project to password protect the files generated by Oracle forms and reports. Since this will only be for internal users, I have used PDFUSER, PDFOWNER utilities given by Oracle.The next tasks is to password protect the files generated ...

I need oracle 8i enterprise edition and Devloper 6i can u teel me the links for them to download I need them very much ......

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

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

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

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