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,210
questions
-1
votes
2
answers
33
views
ORA-00955 name is already in use
I got the error message that the name is already used by an existing object but then it still created the table.
CREATE TABLE InventoryItem (
InventoryID NUMBER PRIMARY KEY,
MovieID NUMBER,
...
0
votes
0
answers
31
views
cx_Oracle.DatabaseError: ORA-01804 on Windows Server
I am currently facing an issue while trying to connect to databases using cx_Oracle on windows server. I have set ORACLE_HOME and LD_LIBRARY_PATH correctly. However, I am encountering the following ...
1
vote
1
answer
42
views
Entity Framework 8 Query Slower Than Direct Oracle Command
I'm currently working on a C# project where I need to retrieve data from an Oracle 19 database. I'm using Entity Framework to handle the database queries. However, I've noticed a significant ...
0
votes
1
answer
45
views
Data Not Displaying Correctly with PostgreSQL odbc_fdw
After connecting to Oracle and DB2 via odbc_fdw and retrieving data, the record count of the tables is displayed correctly, but the data for each record's fields is not displayed correctly.
The value ...
0
votes
2
answers
51
views
SQL Query - Ignore row if data is null for multiple rows on single condition
I have a below table
cid
step
cr_time
120
S02
08-JUL-24 09.35.19.000 AM
120
S03
08-JUL-24 01.35.19.000 PM
120
S04
09-JUL-24 02.35.19.000 PM
121
S02
09-JUL-24 07.35.19.000 AM
121
S03
09-JUL-24 02....
1
vote
2
answers
47
views
My Oracle database 21c express is duplicating my query result in the result tab
The oracle database developer is duplicating my queried data in the table, for example, in the attached screenshot I only insert two rows in each of the 3 tables i.e student table, course table and ...
2
votes
4
answers
48
views
Split String by delimiter position using oracle SQL 28.9 X 30.6
I have a string which contains a '48.6 X 90.6' at COLUMN DIE_SIZE. I want to split this string into size_x and size_y. I can only find a way to split the die_y
Example Strings:
DIE_DIZE
48.6 X 90.6
...
0
votes
1
answer
41
views
Oracle - Shell - Have a list of users to create in DB
In Oracle database, I have to create a list of users from a external SQL file - create_users.sql.
I am trying to automate a refresh process of data from one db to another db. I was successful in doing ...
2
votes
1
answer
34
views
DBMS_PARALLEL_EXECUTE.CREATE_CHUNKS_BY_SQL is called properly but START_ID IS NULL
I call DBMS_PARALLEL_EXECUTE.CREATE_CHUNKS_BY_SQL in different configuration and users. At my personel computer, it works well. below code assigns start_id to 1.
But at business computer, it can not ...
-4
votes
2
answers
62
views
How do I split a string with inconsistent data? [closed]
I have some imperial distances (miles/furlongs/yards) in a column which I am looking to convert into just furlongs. However, the data is inconsistent. Sometimes there is a furlongs value, sometimes ...
0
votes
1
answer
28
views
Redirect to another page after downloading PDF file from REST api in Oracle Apex
I have an interactive report, in which a column is clicked and then a PDF file downloaded by calling a REST API. This column is a link to another page where Before page header process runs and ...
0
votes
0
answers
15
views
Application using OLEDB connection with Oracle 19.18c generating dumps
I'm facing an issue with my application that uses an OLEDB connection with Oracle 19.18c. The application is generating dumps, and so far, we haven't been able to determine the cause.
Details:
...
0
votes
1
answer
44
views
Executing an Oracle function which returns Cursor in JDBC
I have here an Oracle DataWarehouse and have to execute the following function:
function getUserSelection(
p_userID in number,
p_userDate in date,
p_userCompany in string,
p_mode in number ...
0
votes
1
answer
24
views
How to get rid of 0 values from extract, as I think it's causing first and last row to aggregate and give false rows in Oracle?
What I am wanting to do, for each employee, is to get the difference between their clockin, and their next respective clockin in hours, and I am utilizing lag. The problem is, the below select gives ...
0
votes
0
answers
25
views
How can i get CPU Usage by Snapshot with DBA_HIST
I need a query to retrieve the CPU usage percentage of the database at specific snapshot times. For example, my AWR snapshots are taken every 15 minutes, and I would like to know the CPU usage at each ...