in relation with how to copy the records from output of oracle SQL developer to excel sheet I'm using Oracle SQL developer. I've some queries which get some nul
I have a small asp.net core 2.2 app that should access an oracle db; I'm using NuGet Oracle.ManagedDataAccess.Core (2.18.6), and it just works on my machine. W
I am writing this code which throws an error in primary key: DECLARE CURSOR A1 AS SELECT TRANS_DET_ID, (SELECT MAX (NVL(TRANS_DET_DET_ID, 0
I'm converting my total amount into words using bi publisher. Btw, the amount is base on the data from the data set. Can someone help me what to do? Thanks <
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