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

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 ?

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
Courses
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 list out all Oracle UDT and any objects contains java ?

50
hi,

May I know how can I list down which Oracle table has user defined type ?

and how can I …
Troubleshooting Solution

Oracle 10G database server very slow TNS listeners

19
We run an oracle 10g database server running on a windows 2003 server for a web application and we …
Troubleshooting Solution
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

How to encrypt the Apache config file?

9
Hi All,
 We have one Apache web server with java web application (PL SQL and Java). There is a …
Research Solution

How do I simplify a SQL query to make it short and better performance

11
Dear Team,

I am pasting a SQL query which is being used for reporting on monthly basis. I believe …
Troubleshooting 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
Troubleshooting Solution

ORALCE PL/SQL LPAD for Hour string

byASPDEV
15
Hello Experts.

I have a quick thing, in my PL/SQL query I have a VARCHAR2 field for Time which has …
Research Solution

PL/SQL Field Names from CSV file using TOAD

byASPDEV
16
Hello Experts,

I have a task where I get the data from CSV file where I need to import into a …
Troubleshooting Solution

Oracle - Add days and date format

byJDCam
11
Experts,
Two easy things, but combined I cant get them to work.

I want to add 3 days to a date in a …
Troubleshooting Solution

Link server Oracle connect with SQL server

9
Hi Experts,

I need to link the Oracle Database using MS SQL server 2017. using Link server method
Troubleshooting Solution

How to backup oracle binaries

bysam15
25
Hi

I need to patch oracle server with latest security PSU.

The documentation recommends to backup …
Troubleshooting 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 …
Troubleshooting Solution

Trying to resolve a complex PL/SQL query

16
I have a table with columns and data as follows:

ColKey      ColDt1                  ColDt2
A       …

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more