Explore Oracle on Experts Exchange

Expert Solutions for Your Tech Problems

OracleOracle Database

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its prim...

Read more
  • 80K Content
  • 9.9K Contributors

Expert Spotlight
Software Developer

A person who never made a mistake never tried anything new.
- Albert Einstein

FORTIS FORTUNA ADIUVAT
SI VIS PACEM PARA BELLUM

Troubleshooting Solution

How to identify Oracle users with no Privileges and Roles

4
We have databases with many Oracle users but over time some of the users remain in the database but …
Troubleshooting Solution

getting error ORA-01428: argument '0' is out of range

4
Hello,

I am getting error ORA-01428: argument '0' is out of range.
Here is the update query,
 UPDATE …
Troubleshooting Solution

oracle database support levels

byPau Lo
4
I am trying to make some sort of comparison on versions of Oracle Database (on-prem) support …
Troubleshooting Solution

Unable to unpivot in oracle sql 12c

3
Hi Team,
I have written the below query to unpivot the values after pivoting it .

Select *
from
(
Select …
Troubleshooting Solution

oracle once installed with failsafe , can't start up anymore once shutdown

23
hi,

we are setting up oracle 19c and before installing oracle failsafe we can login using SQL …
Troubleshooting Solution

Oracle quick table creation

4
Remember, I'm new to Oracle.  In my old MS SQL Server world I could quickly create a table with


How …
Research Solution

Oracle statistics

7
I say this everytime, I'm new to Oracle.  In my old MS SQL Server world, I could easily get …
Troubleshooting Solution

Oracle date column issue

bygs79
20
We are receiving .dat files from a vendor. The vendor has also supplied a   custom program written …
Troubleshooting Solution

Create an Oracle oledb 64 bit connection fails

3
I have installed ODAC122011_x64 with an Oracle Client, only installed the oledb driver. I need a …
Troubleshooting Solution

Is there a way to utilize an Oracle wallet via PHP on windows?

byJezhra
3
I have a PHP codebase that resides on a Windows server that connects to an Oracle database.  My …
Troubleshooting Solution

Oracle - Subselect query syntax

byJDCam
21
Experts,
I am trying to add a subselect to an existing query and struggling with the syntax. The …
Troubleshooting Solution

Oracle table cascade delete

8
Is it possible to create some constriant such that deleting records in purchaseOrder will remove …
Troubleshooting Solution

Oracle SQL Query

9

Is it possible to classify the above rows into several group with SQL ? Thx

Troubleshooting Solution

Table schema definition on Oracle table

5
Is it possible to list the schema definition, referential reference and trigger definition defined …
Troubleshooting Solution

Check Null value in oracle SQL

3
I find that the following sql will also include those null records for right table even though I …
Troubleshooting Solution

Oracle SQL Query

18
I find that the Oracle sql can't filter the date properly. I suppose any effective date equal or …
Troubleshooting Solution

Oracle SQL Query

10
select b.itemNo, b.effectiveDate, b.unitCost from ToBePurchased a
left join itemCost b  
on a.itemNo = …
Troubleshooting Solution
Troubleshooting Solution

Problem running Oracle procedure

5
I have tested the SQL statement and it can creates record in Oracle table. When putting the …
Troubleshooting Solution

Error ORA-0001

4
any one ideas how to slove the error?


execution code:
BEGIN

  purchaseAdmin.CheckBelowMinStock;      

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more