152,517 questions
-3
votes
0
answers
42
views
Oracle database procedure throws ORA-00060 error [closed]
I have 3 different tables in which we first time insert the data and update for same case from 3 others tables.
We have 1500 columns used for selecting and updating, also there is a master like get ...
- 1
Best practices
0
votes
0
replies
38
views
SSIS oracle connection
I'm working on an SSIS project and using oracle database as source but since microsoft is not supporting the old tools I'm having trouble finding a solution. I'm using ODBC but I always get a licence ...
- 1
-1
votes
1
answer
74
views
How to fix the Connection Failed message in SQLcl
I have just installed SQLcl and Oracle database 21c express edition and also added the path in environment variables. All the services including OracleOraDB21Home1TNSListener are running successfully, ...
- 1
-6
votes
0
answers
45
views
IOT tables not Imported [closed]
In Oracle Database, during a Data Pump import, some IOT (Index-Organized Tables) were not imported successfully. How can I identify the cause and import the missing IOT tables properly?
- 1
1
vote
0
answers
72
views
FromSqlRaw fails with column that contains NULL
I am using EF Core 10 (Oracle.EntityFrameworkCore) with an Oracle backend. I am executing a query using FromSqlRaw. The query is quite complicated, but it works. The query result is not a direct ...
- 185
1
vote
2
answers
96
views
Intersecting Multiple times against the same table (set) on JOIN
Perhaps I'm missing something, and I know SQL is set-theoric, but I just can't figure this out.
Table Account:
| id | zip_code_id |
Table Package:
| id | name |
Table Account Package:
| account_id | ...
Best practices
0
votes
0
replies
42
views
Best way to connect AWS DMS to on-prem Oracle database (private network) – high-level architecture guidance
Description
I am working on setting up AWS DMS to migrate data from an on-prem Oracle database to AWS.
The source database is hosted on prem, and I will be handling the AWS side of the setup. However, ...
1
vote
1
answer
54
views
Autonomous database connection issue from PowerShell
I was able to connect to the Autonomous Database on OCI and through the web. However, I am not able to connect from PowerShell on my personal Windows laptop using SQL*Plus 21c. I successfully ...
Advice
0
votes
8
replies
100
views
Construct the pattern for a REGEXP_SUBSTR in Oracle
I have a column of data:
blah blah blah [this text 1] yada yada [that text 2] da-da-da
I want the output to be:
this text 1, that text 2
In essence, I need to capture whatever is between the [] ...
Advice
1
vote
3
replies
61
views
Oracle Scheduler Jobs are sending phantom notifications
We have several databases among those a Prod and Test Oracle environment. At one time the Prod database was refreshed into the test database. With that refresh came all the scheduler jobs and ...
- 1
-1
votes
1
answer
99
views
Handling outliers of ratecard in Oracle [closed]
I am trying to handle values that do not match the ratecard. Working in Oracle SQL.
Here is the scenario: cost is fetched from Rates table:
product type
power start
power end
height min
height max
...
- 5
Best practices
0
votes
5
replies
87
views
Filling Null values with MEDIAN in Oracle Database table
I have table TABLE_ORIGIN with a primary key PK_ID and a numeric column COLUMN_NAME with some Null values.
I want to create a table called NEW_TABLE with columns PK_ID and COLUMN_NAME but I want to ...
- 1,029
2
votes
1
answer
96
views
Oracle OFFSET/FETCH returns identical rows for different offset values when ORDER BY is non-unique
This is a follow-up to this question which shows the symptom but doesn't explain the internal mechanism.
Setup:
CREATE TABLE t (x INT, name VARCHAR(100));
INSERT INTO t
SELECT level,
CASE WHEN ...
Advice
0
votes
9
replies
79
views
Getting percent but total percent is sometimes 99 or 101
I have this query my goal is to get percent
NVL(ROUND(100 * NVL(activeCount, 0) / NULLIF((NVL(activeCount, 0) + NVL(blockCount, 0) + NVL(closeCount, 0) + NVL(draftCount, 0)), 0), 0), 0) AS ...
- 15.6k
2
votes
1
answer
115
views
Is it possible to run an Oracle package to create a table via JDBC
I am trying to move a database creation process from SQL plus to JDBC. I need to run a bunch of processes attached to Oracle packages.
BEGIN
ddl.column('table_name', 'column_name', 'type')
END
I ...
- 321