Questions tagged [oracle]
Oracle Database is a Multi-Model Database Management System created by Oracle Corporation. Do NOT use this tag for other products owned by Oracle, such as Java and MySQL.
oracle
58
questions
0
votes
0
answers
15
views
Check to see if a specified month falls within an identified timeframe with begin/end dates
I have two column dates start_date and end_date in a table. I'd like to find out if for a certain month within the year 2024, a member is subscribed for the identified month.
An example, timeframe is ...
- 109
0
votes
0
answers
12
views
How to write a MD5 SQL Code in Oracle similar to Informatica Expression Logic for Validation
My requirement is to write a sql code to replicate the MD5 Logic used in informatica expression transformation for Validation Purpose . The MD5 used in Informatica is MD5(TRIM(AGRMNT_NO)||TRIM(SRC_CD))...
- 239
0
votes
1
answer
39
views
Discrepancy Between SQL Server and Oracle months_between Function Outputs
I'm working on a project where I need to calculate the number of months between two dates in both SQL Server (using Synapse) and Oracle. I've created a user-defined function in SQL Server to replicate ...
- 23
0
votes
2
answers
45
views
Is there any method to convert a varchar with specific format into time in Oracle SQL?
I have a table with three columns, one of the columns ateststatus_date has the following format: e.g:
28-MAY-24 11.57.20.000000 PM
and it's defined as varchar(2). I used To_date() and ...
- 11
0
votes
0
answers
11
views
Oracle Forms fails to start up on OL9 - cannot find shared object file libopmnperf.so
I have freshly installed a 19c Database and an Oracle Forms and Reports 12.2.1.4 instance on an Oracle Linux 9 VM and everything starts properly except for the Forms application. When I try to start ...
- 11
1
vote
3
answers
43
views
Converting char to date and pulling past two years data
I need to pull data from tables with millions of rows and limit it to just the past two years. I am working on developing a SQL statement to enter into Power BI to limit what it pulls. Obviously I am ...
0
votes
0
answers
25
views
Oracle: how to add a decimal point to an integer [duplicate]
Oracle 19c.
I am reading a file and need to store the following values into a NUMBER column:
000036720
000008425
000754070
000086640
000001645
Desired output will be:
367.20
84.25
7540.70
866.40
16....
- 481
0
votes
0
answers
31
views
Struggling to understand oracle database listener.ora file [closed]
I wanna preface this by saying that I have 0 oracle database knowledge and right now I am facing the following issue:
At my job we used to build custom oracle db docker images using rpm files and ...
- 137
0
votes
0
answers
14
views
Oracle ORA-04068, Error when Making Changes to Package ODP.NET Project [duplicate]
I am encountering errors while interacting with an Oracle database from C# using pooling true connections. Specifically, when I make changes to a package in Oracle, I receive the following errors on ...
0
votes
0
answers
33
views
Call PL/SQL from JDBC has different behaviour with OracleConnection and Connection
I need to change package variable using JDBC and get new value back.
Oracle package:
create or replace package test_pkg
as
test_num number := 10;
end;
When I do it via java.sql....
- 363
-1
votes
2
answers
39
views
Materialized view log fast refresh memory management
I have a materialized view which is currently refreshing in complete mode (taking around 30 mins to refresh). I'm trying to optimize it by changing the refresh mode to fast. As the history data in the ...
0
votes
0
answers
37
views
Sporadic failures in FastAPI SQLAlchemy deployment due to database connection errors
Our FastAPI deployment uses SQLAlchemy to connect to our database and fetch/filter metadata, but it is proving very flakey. Load balancing tests using Locust show a very odd behavior where initial ...
- 23
0
votes
0
answers
20
views
I need to make the existing non partitioning table as partitioning table and non partitioning table has many linked child tables [migrated]
The main table is linked with many child tables using foreign key. And need to add the list partition in the main table but i want all child table will also be linked with this partitioned table. ...
1
vote
0
answers
23
views
Oracle 11g and EF Core 8 two similar servers one throws an error "OracleException: ORA-28040"
Looking for some help/advice.
I have two Oracle 11g servers call them "TEST" and "PROD". When I run my project it connects fine to "TEST" but when trying to run it with &...
- 78
1
vote
1
answer
12
views
VS Code Drag and Drop Database to .ipynb Not working?
Currently test driving the new Oracle SQL Developer extension for VS code and was referencing this Youtube Video: https://youtu.be/e-yqkI0t6dQ?t=2784
Noticed the presenter had a database open and ...
- 163