Getting read only file system error when try to create local repository for docker. [1] I used this installed lima [2] over Macbook Air M1 (Apple chipset) chown: changing ownership of 'oracle-19c/....

Given this table create table FOO ( ID number(19) primary key, DATE1 DATE default sysdate, DATE2 DATE ); DATE1 is initialized with sysdate when I insert a row, then set to null and then copied ...

all I'm trying to connect to an Oracle 19C database. I have installed two Oracle Clients (11g and 12c) because we need to support legacy programs. I can connect with no issue with any user using sq...

I am working with Oracle 19c in centos 7. After Oracle installation, i created new Container Database(CDB) with Plugguble Database(PDB) using DBCA. I am working with port number=1522 [oracle@ol8-19...

I am running Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.8.0.0.0. Consider the following example: create table tab_a as select 1 as id from dual union all sel...

One of our database was upgraded to Oracle 19c and now my application is unable to connect to database I am getting the following error. HHH000400: Using dialect: org.hibernate.dialect.Oracle12c...

I want to Install Oracle Database Express on macbook m1 but it only supports linux and windows, I downloaded Sql developer but I m unable to download Oracle database. I tried to install using docke...

I am trying to install oracle 19c DB but after extraction the setup.exe file isn't executing. I have tried it with admin privileges, still doesn't work.

On migrating my local Oracle DB on Windows, from 11g to 19c, while running the setup.exe, I got a: [INS-30014] Unable to check whether the location specified is on CFS

I think there was a function extract(quarter from date) in oracle sql to fetch the quarter for a given date. However the Oracle SQL 19c documentation here does not show the presence of quarter anym...

Working in an Oracle 19c database on Linux x86/64 trying to convert non-partitioned table to partitioned table. Since Oracle12, alter table modify partition has been available to convert non-partit...

What happens if two transactions try to modify the same row simultaneously? Normally, once the row is modified, the other transaction waits until the first one performs commit or rollback. But what...

Is there a simple Oracle syntax like a ternary operator or function? These work: with function qry(v in varchar2) return varchar2 is begin return owa_util.ite(v like ('%' || lower('something') ||...

so we migrated Oracle 12.2 to 19c and the Asp.Net app that connects to oracle service is now failing with the following error: Oracle 12560: TNS Protocol Adapter Error before anything, I'd like to ...

I am using Spring boot(2.3.5), Oracle19c DB, and Hibernate(5.4). I tried to make multi-datasource connection, but I keep getting a dialect error Couldn't determine Dialect for "oracle". ...

Using Oracle 19c: I have the following query in which a Sub-Select (linked to the main Select via plans1_.ID) uses the JSON_ARRAYAGG function. select ... , /* Other columns... */ (SELECT json_ar...