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
12
questions
0
votes
0
answers
4
views
How to specify multiple search criteria with the emcli list command?
The below code returns the desired result set.
emcli list -resource="Targets" \
-bind="TargetType='oracle_database'" \
-columns="TARGET_NAME:20,TARGET_TYPE:20" \
-search=&...
0
votes
0
answers
14
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))...
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 ...
0
votes
2
answers
46
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 ...
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 ...
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....
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
34
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....
-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
38
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 ...
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. ...