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

Days between two dates in Oracle SQL.

17

how do I calculate the difference between dates in days in oracle SQL ? I am trying to get a

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

Establish connection from Oracle DB to MSSQL Server

22

Hi,

We are running into challenge while connecting to SQL server 2008 hosted on Windows server 2008

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

change oracle 19c system password

33
hi,

I sqlplus to a oracle 19c box and it say SYSTEM  password will be expire in 7 days, what is the …
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 …
Research Solution

I need quick tutorials and topics for SQL Server expertise.

6

I need quick tutorials and topics for SQL Server expertise.


I am a .NET developer and hope for an

Troubleshooting Solution

linux shell

bybibi92
8

Hello,


How can I modify this command line to detect automatically  linux account starting oracle

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

Need help with a stored procedure

12
Need to create a stored procedure that deletes the lines of a table and copies the data. How would I …
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

VB.Net - Connection string to Oracle 11g dbase

21
Hi

In my previous VB6 application, i was able to connect to my oracle 11g tables using the …
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

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

Article

How to Unravel a Tricky Query

10
How to Unravel a Tricky Query

Introduction
If you browse through the Oracle zones or …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more