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
Alex [***Alex140181***]Software Developer

A person who never made a mistake never tried anything new.
- Albert Einstein

FORTIS FORTUNA ADIUVAT
SI VIS PACEM PARA BELLUM

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 ?

Article

How to FTP with Oracle PL/SQL

22
Sometimes you need to get data from a server into your database, or from your database into a remote…
Video
Executing a SQL Script from a Unix Shell Script and Passing Parameters

Executing a SQL Script from a Unix Shell Script and Passing Parameters

2
This video shows how to set up a shell script to accept a positional parameter when called, pass …
Courses

Introduction to Oracle SQL

Beginner
Learn how to use Oracle SQL from scratch with this video course.
In this course, you will learn:
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 …
Solution

Complex SQL query

58
I have two tables Tbl1 and Tbl2. I have a SQL as follows:

select Tbl1.Col1, Tbl1.Col2, Tbl2.ValA…
Video
Send Email From Oracle Database

Send Email From Oracle Database

7
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and …
Solution

dbms_lob.substr is causing perfomance issues, running out of  32GB of 'TEMP' table space in Oracle

byWAS
16
I am trying to understand sql query written by my previous employee, we are using dbms_lob.substr …
Solution

set oracle buffer pool for different application.

54
hi,

I heard that we can setup different buffer pool for different application, is that right?

Solution

Querying Oracle from VBA slow only the first time

21
I am querying an Oracle database remotely from a VBA project; the query is below. The first time …
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 an SMTP server with Oracle PL/SQL.


Solution

Add number range dynamic partition

16
Hi,

I have a table

premium
-------
time_key     NUMBER(15,0)
amt          NUMBER(12,2)

Solution

How to say goodbye

14
OK, this "question" is probably abusing the purpose of this site, but I plan to do this only once, …
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 …
Solution

Left join with condition is failing in  oracle

13
Hi Experts,

I am trying the below query leftjoin with and condition
but still i am fetching the…
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 …
Solution

Dynamic sql using execute immediate

14
Hi Team ,

Below is the dynamic sql , Iam trying to generate using execute immediate



Solution

Multi-cursor

14
I am using Oracle SQL Developer 18.2.0.183.  I have gone to Tools -> Preferences-> Mouse Actions -> …
Solution

migrate oracle to oracle cloud.

16
hi,

if I want to migrate from oracle to oracle cloud, what is the approach and what is the tools …
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

Take a Class

Collaborate

Monitor your Site

Explore solutions and more