I am trying to create a database in order to complete my self learning, but unfortunately I got unexpected error "Unable to check for available memory.", I am doing it using Database Conf...

We have a J2EE application on a payara 5.2020 server that executes a long running query (PL/SQL that executes for a couple of hours). To avoid a timeout exception, we use this sentence at Statement...

Test #1: I have a user-defined function and a CONNECT BY LEVEL query: with function custom_function(p_id in number) return number is begin return p_id; end; select custom_function(level) from...

Hi I've tried to create a new user in Oracle 18c XE, but I get ORA-65096: invalid common user or role name error when writing create user student identified by "student"; I've tried to change ...

When trying to save a trigger I get this error Connecting to the database XE. Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '192.168.56.1', '59537' ) ORA-24247: network access denied by acces...

I am trying to create an Oracle Database container that has an SSL enabled listener for connections. But I am having trouble getting the listener to start. I have tried many configurations but here...

After migrating to Oracle 18c Enterprise Edition, a function based index fails to create. Here is my index DDL: CREATE INDEX my_index ON my_table (UPPER( REGEXP_REPLACE ("DEPT_NUM",'[^[:alnum:]]'...

Is there a Hibernate dialect for Oracle Database 18c? Or should I use the org.hibernate.dialect.Oracle12cDialect that ships with Hibernate? When using Hibernate 5.3 and Oracle 18c RAC is there any...