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

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
Article

PowerSchool ODBC

PowerSchool SIS ODBC
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

: sed: command not found

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

oracle@hostname dbhome_1]$ …
Post

PowerSchool SIS ODBC (Oracle DB connection)  Thanks to Evan …

PowerSchool SIS ODBC (Oracle DB connection)

Thanks to Evan Hines & slightwv for pointing me the …
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
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

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 …
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 …
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 …
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

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 …
Troubleshooting Solution

Question with Oracle / Coldfusion SQL Query based on max date

16
Hi All!! Im having trouble with a query that Im hoping to get some help on. I have a very simple …
Troubleshooting Solution

How to update a table from another in between specific values

16
Need to update a table named QQM_OUTBOX which contains XML code within a column named payload. Need …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more