I want to write a programm that first checks if a column is only populated with NULLs before updating the column. I have written what I thought should work, how
Trying to execute a procedure in perl script, Proceure ->create or replace PROCEDURE Getproc ( v_catg IN CHAR DEFAULT NULL, v_cursor OUT SYS_REFCURS
I have sample data like this CREATE TABLE table_name (aktif, "START", "END", NO_BOX, QTY) AS SELECT 1, 'A0001', 'A0020', 2016, 100 FROM DUAL UNION ALL SELECT 1,
I have a table, it's going to be used for a supplier scorecard, with eleven different fields that can be assigned a value of 1-5. Null values are allowed. I
There is a date column used in OBIEE analysis. That column is declared as 'date' datatype in Oracle table, type in rpd is also 'DATE'. However, when exported to
Using Visual Studio 2017 and SSIS. Basic data flow from Oracle to SQL Server. Oracle is source (OLEDB) and SQL Server is destination (OLEDB also). I'm using
I am using oracle DB. I have a Aggregated script. We found that some of the rows in the table are repeated, unwanted and hence, is not supposed to be added in
I am trying to execute a simple stored procedure using Oracle OCI. The stored procedure takes a string as an input and copies it to the output parameter. Below
I have a function which is not working as expected. How can I modify to get the desired output? CREATE OR REPLACE FUNCTION f_get_all_programs_test( pidm in num
I am trying to create a C++ application with OCCI (versions 11,12,18, all lead to the same issue explained below) using gcc 7.1. The application below compiles
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