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 Question

Visual Studio 2017 desktop app not opening on client's computer

4
Hello,

I have a VB.Net desktop application I created for internal use in my company. It connects to …
Troubleshooting Question

ERROR: ORA-12560: TNS: protocol adapter error while doing shutdown the Oracle Database

11
While progress of enabling Archive log on Oracle Database, on Step shutdown i get this error  and …
Troubleshooting Question

How do I create a Report Builder 2016 dataset based on a procedure or a function with parameters in Oracle?

bytancat
1
I am trying to create a dataset in Report Builder 2016 using either a procedure or function in …
Opinion Question

Oracle backup sotware

9
Looking for recommendations for 3rd party Oracle backup software. We are using RMAN (Oracle 19c) …
Troubleshooting Question

How to do I append the new file into a table without duplicate, can I verify dates if exist, and if not then append new file?

4
This is my ctl file and I have a folder, in a folder has a  stack of files, old date is already …
Troubleshooting Question

Best method to call another script after a program finishes successfully

5
I am an Oracle DBA that has databases sitting on a Linux VM (RHEL 7).  I have been tasked to copy …
Troubleshooting Question

how to user oracle client is asp.net c# in 2015

5
We are getting error while connecting Oracle 19c Database in .Net 2015. 
Research Question

setup active data guard between 2 x nodes Oracle 19c failed safe cluster on Windows with a standalone oracle 19c

17
hi,

any good setup guide to help setting up and configure active data guard between 2 x nodes Oracle …
Troubleshooting Question

Oracle SQL Query

6
Can we only display the max. total per year (ie. 2 rows) using JOIN or SELECT, without the use of …
Troubleshooting Question

How to find if the employee is not a supervisor

3
I have the following query
Now i have to add one more column with value 'is supervisor' or 'not a …
Research Question

Is it safe to install Oracle SQL Developer on a SQL 2012 server?

byisames
6
Is it safe to install Oracle SQL Developer on a SQL 2012 server?
Troubleshooting Question

oracle procedure wrong result

2
i am creating a procedure which reads through all the rows in the ToBePurchased Table and produces …
Troubleshooting Question

Oracle APEX Gantt Chart Axis Customization

byYZlat
Is there a way to customize what is displayed on major or minor axis of the Gantt chart? For example …
Troubleshooting Question

Oracle 8i RBS datafile corruption

10
I have an old 8.1.7 Oracle database that had disk corruption on a rollback segment datafile due to a …
Troubleshooting Question

How to change in "Oracle SQL Developer Version 19" the date format in "export to excel"?

3
When I export in "Oracle SQL Developer Version 19" data to excel 2003+, SQL Developer sets the date …
Troubleshooting Question

Oracle APEX Report Parameters

2
I have a call to report built in Oracle's Application Express (APEX).  

The URL is …
Troubleshooting Question

How do I append to a clob in a database table where the value to be appended is greater than 4000 characters?

bytancat
7
I inherited some code in an 11g/12c database that has a table with a field that is a clob.  The …
Troubleshooting Question

Oracle error ‘more than requested no of rows’

byDg Ax
11
  • I am giving a alter table command with default value
  • There is an audit log trigger on the table which
Troubleshooting Question

need to extract 1 row

6
I have 2 selects in an union. however, I need only 1 row as an output. We have both negative and …

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more