I would like to know if oracle 19c is compatible with jdk 7. I have found out 2 drivers for oracle 19c ojdbc8 : for jdk8, jdk9 and jdk11 ojdbc10 : for jdk10 and
Background: I need to create a web application that connects to an Oracle database hosted by my university through a VPN. The app does not have to be hosted onl
I have a comments column and the comments added to release are stored as rich text in comments column. Now i'm trying to process this data and get an human read
How should I iterate over a table of objects like this? CREATE TYPE SOME_OBJECT AS OBJECT ( ATTR1 VARCHAR2(20) , ATTR2 VARCHAR2(30) ); / CREATE TYPE C_SOME_
In Oracle Apex SQL Workshop, is there a set of hot keys to activate the Run Command? I've researched this online and have not found an answer. It seems labori
I have created an oracle free tier account a few months back and tried to log in one day and my db instance along with apex and all my work disappeared. I don't
I have a view with some columns in it. How to check that those columns of the views is extracted from which base table? How to get base table of a column in a v
Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there
I am using JOOQ ( 3.10. 5 ) to update records in ORACLE table without jooq auto code generation in below ways Approach 1- Using DSL execute by using plain SQL S
we have application .net core with oracle database published since 8 months unexpectedly returned request connection time and we didn't make any deployment and
I am trying to write a trigger on one table that is triggered when the quantity in stock = 0. It will then add a row to another table with the product_id and st
Oracle newbie here just trying to learn something. I have a query that returns two rows per ID: SELECT B1_ALT_ID, B1_CHECKLIST_COMMENT FROM PERMIT WHERE (B1_CHE
I have multiple report pages. I am working on a system that stores a lot of data. Is it possible to have reports that are able to have column edited on two diff
I have found an issue with the Oracle OLEDB Driver “Oracle Provider for OLE DB” and MS SQL SSIS Packages. This was first found in SQL SSIS packages
I'm writing a Python script to fetch some values from Oracle, but by the middle I have to set an ID to a package so it can create the corresponding view with th
I have developed a .Net C# based website, which is dependent mostly on Oracle database. To access the DB I have been using Oracle ODAC 11G. (Oracle.DataAccess.d
So i have a query that i would like to execute through a stored procedure and export the output of the query to a CSV file. But only the last column name is not
I need to add a validation in the following way. There's a drop-down list with two attributes(let them be A1 & A2) and an Input Text box. I need to let the
I'm working on some Oracle DB problem. Is there any possibility, to check if table or column exists, before I want to modify it? If it doesn'
I'm working on some Oracle DB problem. Is there any possibility, to check if table or column exists, before I want to modify it? If it doesn'