I have a task to import some data from Postgres database to Oracle via dblink The connection between Postgres and Oracle works good, but unfortunately, when I t
Good day, everyone! I've got a bunch of sequences. For example: CREATE SEQUENCE seq_id INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 20000
I'm trying to select user role from Oracle database using id of user in spring boot framework but it not working? I'm trying to select user role from Oracle
I have a requirement to change the owner of an interactive report and also change the interactive report from public to private. I am aware of the APEX_IR.CHANG
I have a c# MVC web application (.NET 4.52) using an older version of Devart LinqConnect to scaffold the database etc. The app has been around for 10 years wit
I have tried to configure an AWS DMS Endpoint, but when I try to do the connection test it shows me the following error: Test Endpoint failed: Application-Stat
In the code base I am working with we use the oracle instant client library as a third party dependency in Bazel as follows: cc_library( name = "instant_cli
i have a procedure that give me a refcursor as out parameter and i have to join that data with other tables in my own package. i try to fetch cursor in a variab
I'm creating an ASP.NET API Core application, to handle API services, which communicate to an Oracle Database. At runtime, when the process tries to connect to
I'm writing a Python script with CX_ORACLE which will take about 20K files and upload them into a BLOB column. They are PDFs,CSVs,TXTs, and JPGs. I'm just not u
Are there open-source solutions to share Oracle connection pools across server instances so application instances don't suck up limited connections? For example
My user has the following privileges: `GRANT CREATE SESSION to user1; GRANT SELECT ANY TABLE to user1; GRANT SELECT_CATALOG_ROLE to user1; GRANT SELECT ANY DICT
I need to get a NEXTVAL from a SEQUENCE in an Oracle database. The modelbuilder does have a builder.HasSequence("TABLE_SEQ"); But I have no clue on how to use
I have an issue with SQL developer where the GUI language won't change as it shows here Now I have tried the solutions where I added the following to sqldevel
Initially I was getting this exception while starting my service An attempt was made to call a method that does not exist. The attempt was made from the followi
I am using a PIVOT to combine two rows with the same ID into a single row: SELECT B1_ALT_ID, B1_CHECKLIST_1, B1_CHECKLIST_2 FROM B1PERMIT A JOIN BCHCKBOX B ON A
I am needing to create a view, and one of the columns in the view needs to calculate a value for the metric. The source table for a metric will be different dep
I need to use Oracle bitwise operation in my project. I know there is the BITAND() available for the purpose. As far as I know BITAND() is the only such opera
I've created two tables: Employees and Departments CREATE TABLE EMP ( emp_id number(3) PRIMARY KEY, dept_id Number(3) NOT NULL, emp_name Varchar2(50) NOT NU
I am trying to insert into a table, whose values are same except few from the same table with max sequnce number based on an ID. insert into ENT_ROLE_USERS_HIST