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
Database Administrator / Software Engineer

Over 20 years of experience as an Application Architect/Developer, a Database Administrator, and a PM focusing on performance.

Troubleshooting Solution

Oracle Virtual Machine

17

What is a virtual box and how do I use it?



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

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

Best way to create read-only user in oracle

bysam15
27

Hi

I have an oracle 19c application schema "HR" with 200 tables.

I created 30 new oracle users with

Advice Solution

Disallow the use of select * from

byIVL
30

We have a lot developers coming and going.
We keep explaining them not to use select * from queries

Research Solution

oracle on peacemaker and RAC, which one is preferrable ?

35

Hi,


Currently we have oracle on each of linux 2 x nodes and the failover is by peacemaker, so

Video
Research Solution

good business case study on migrating from oracle 12c to MS SQL

23

hi,


we are trying to propose oracle 12c to MS SQL 2019 migration, but any pros and cons comparison,

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

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

Formatting output on 19c

18

Hello Experts, 

Need your view on how to change or reorder the data based on one column conditon. 

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

Research Solution

tfactl diagcollect  on oracle linux box has error

19

Hi,


When we are running on a linux oracle box and when we run TFA on the redhat linux box: it shows

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

Who can improve this SQL?

18

Edited:

Even though the end result will be Postgres, I would entertain SQL from other leading

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

Optimize the SQL

22

Optimzing this SQL which is taking huge time, 




My   acl table is having 30679616 rows and ACCT  

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more