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
152,178
questions
-1
votes
0
answers
8
views
How to use incremental data in stored procedure fetching in a table basis on serno. For eg: latest max serno is 100 at t=0, 103 at t=1, so on
I have to include this incremental data in stored procedure to generate file from t=0 and t= time take by procedure to complete.
select max(serno) from incremental_src ;
o/P: 100 at t=0
o/P: 105 at t=...
0
votes
0
answers
8
views
Hibernate: Generate non-id value from sequence
I have an entity with 2 fields which both use the same sequence, but when debugging I see that only the id field value is being generated:
@Table(name = "MY_TABLE")
public class MyEntity {
...
0
votes
0
answers
11
views
What is required for Oracle Data tools and VS 2022?
Cannot get oracle data tools to connect in VS 2022
Will not connect using odp.net managed driver
keep getting "ORA-12545 unable to resolve connect hostname"
will connect using legacy ,net ...
0
votes
1
answer
10
views
Update Onprem oracle table from aws glue python shell using oracledb
I have a usecase that needs to update an onprem table using the aws glue python shell.
Please note i want to use python-oracledb in thick mode
I have installed the oracledb
I dba has set up a jdbc ...
0
votes
0
answers
13
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
2
answers
45
views
Joining tables with different date formats (Literal does not match format string)
I'm trying to join two Oracle tables (basically to pull in a daily rate against the date in another table), but the table I'm pulling the date from has the timestamp in it. I'm seeing a lot of ...
0
votes
0
answers
15
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
42
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
49
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
49
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
16
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
37
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
40
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 ...