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

Plan statistics - Am I reading this correctly???

108
Hi Experts, I hope you're looking for a challenge today.  
This is my query.  The values in brackets …
Article

How to FTP with Oracle PL/SQL

24
Sometimes you need to get data from a server into your database, or from your database into a remote…
Video
Tutorials
Post

Can anyone explain this?  When looking for transactions …

4
Can anyone explain this?

When looking for transactions based on timestamp in e.g. 2017 you can …
Troubleshooting Solution

Limit SQL result set based on SIZE

46
I'm an oracle dba and have been asked by developers to help them limit the result set size produced …
Troubleshooting Solution

PLS-00172: string literal too long

69
Hello Experts,

I have Oracle procedure and the input parameter is a CLOB but now the input volume is …
Video
Troubleshooting Solution

Dynamic changing of dblink in Oracle sql

byRads R
137
How to concatenate dblink which will change dynamically in a Oracle SQL Statement at the end of the …
Troubleshooting Solution

Connecting to oracle 19c through java application facing this issue java.sql.SQLException: Io exception: NL Exception

12
Hi Experts,
I am trying to connect oracle19c database through java application.
facing below error.

Article

PowerSchool ODBC

PowerSchool SIS ODBC
Article

How to Send Email Attachments with Oracle

11

How to Send Email Attachments with Oracle PL/SQL 

By Sean D. Stuber


Part I: How to Authenticate to

Troubleshooting Solution

: sed: command not found

25
hi am having the following issue when setting path
oracle@hostname

oracle@hostname dbhome_1]$ …
Troubleshooting Solution

error installing oracle software

34
hi am having this error when installing oracle software
 java -jar fmw_12.2.1.4.0_infrastructure.jar
Troubleshooting Solution

Finding special characters for Printjoin in Oracle  (DRG-51030)

35
Hello,
I have recently learned about Oracle Text and have implemented it to help a developer with his …
Article

How to Unravel a Tricky Query

10
How to Unravel a Tricky Query

Introduction
If you browse through the Oracle zones or …
Troubleshooting Solution

procedure to install oracle on linux VM if I have the RPM package

117
hi,

any step by step procedure to install oracle on linux VM if I have the RPM package ?

Research Solution

how to setup oracle maintenance job

35
hi,

have new oracle 19.2 setup on Windows server, how can I setup
1. RMAN backup regularly
2. Auto …
Troubleshooting Solution

What internal value did Oracle Database store?

bydeleyd
11
I have an Oracle database. A column "mycolumn" is defined as 'Number' format. I run Oracle SQL …
Research Solution

Search for a value in a Oracle schema

86
Hi,
Can you please provide a query/procedure that will display the table_name, column_name for a …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more