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
  • 81K 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

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

how to compare 2 comma seperated strings in oracle sql

15

I want to write a sql or pl/sql function anything. My moto is to compare 2 comma seperated strings. 

Troubleshooting Solution

Convert  output of query from utc time to cst time

14

The INCOMING_HEARTBEAT_TS column is in UTC time and so the output of the query is in utc time. I

Video
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 ?

Troubleshooting Solution

Oracle to Access --ODBC error

58

I am creating an ODBC from an ORACLE database to an Access database.   The ODBC checks ok in control

Troubleshooting Solution

Error when connecting to newly installed Oracle 11gR2 express edition by SQLPlus.

111
hi,

I just install the oracle 11gr2 express on Windows and now I try to login (actually I follow …
Troubleshooting Solution

What are better SQL options than "IN ( 'value1', 'value2', 'value3)"

11

I have a major performance problem with "IN".


What are my options?


I would need to put 10K-20K items

Research Solution

the way to downsize Oracle database to MySQL

26

Hi,


Right now we want to have  wish that we try to  downsize Oracle database to MySQL, as far as I

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

How setup multiple Oracle DBA_accounts

bysam15
31

Hi


If you have a few Oracle DBAs doing adminsitration for Oracle Server 19c on RHEL 7, is it normal

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

Total count of a field from all schemas grouped my month

91
I need a query or script that gives me a COUNT on a particular column from a …
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 …
Troubleshooting Solution

Extract Value based on Delimiter

byfb1990
14

Hello Experts,


Can someone please help me parse specific data from the URL below using SQL?  Here is

Troubleshooting Solution

oracle 19c database  on windows server 2019, unable to connect via tns/sql developer.

19

i have windows server 2019 standard and oracle 19c databases installed on it. All the other

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more