Dynamic changing of dblink in Oracle sql
How to concatenate dblink which will change dynamically in a Oracle SQL Statement at the end of the …
![Oracle]()
Oracle 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 25 years of experience as an Application Architect/Developer, a Database Administrator, and a PM focusing on performance.
Leading Experts In
Troubleshooting Solution
Article
How to FTP with Oracle PL/SQL
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
This video shows how to set up a shell script to accept a positional parameter when called, pass …
Tutorials
Introduction to Oracle SQL
Learn how to use Oracle SQL from scratch with this video course.
In this course, you will learn:
…
In this course, you will learn:
…
Post
Can anyone explain this? When looking for transactions …
Can anyone explain this?
When looking for transactions based on timestamp in e.g. 2017 you can …
When looking for transactions based on timestamp in e.g. 2017 you can …
Article
Eliminating Runtime Transformations with Generated Columns and Functional Indexes
This article examines Functional Indexes and Generated Columns as solutions for poorly optimized SQL. It demonstrates how moving transformation logic to the storage layer optimizes legacy system integration and semi-structured JSON data, significantly reducing CPU consumption and latency.
Video
Send Email From Oracle Database
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and …
Troubleshooting Solution
procedure to install oracle on linux VM if I have the RPM package
hi,
any step by step procedure to install oracle on linux VM if I have the RPM package ?
…
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.
hi,
I just install the oracle 11gr2 express on Windows and now I try to login (actually I follow …
I just install the oracle 11gr2 express on Windows and now I try to login (actually I follow …
Article
How to Unravel a Tricky Query
How to Unravel a Tricky Query
Introduction
If you browse through the Oracle zones or …
Introduction
If you browse through the Oracle zones or …
Article
Oracle Instant Client Install Instructions - 64-bit Windows
To download and properly install Oracle Instant Client on your 64-bit Windows client, follow the instructions located within this article
Troubleshooting Solution
Total count of a field from all schemas grouped my month
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???
Hi Experts, I hope you're looking for a challenge today.
This is my query. The values in brackets …
This is my query. The values in brackets …
Troubleshooting Solution
Filtering incoming data with the same timestamp
I have neural network which get every second set of data analyze it and generate result. I collect …
Troubleshooting Solution
Connecting to an Oracle DB on RedHat Enterprise Linux 7 in the Azure cloud
We have the database up, running functional and can hit it locally when we login to the Azure/RHEL …
Troubleshooting Solution
preparation work for PoC procedure from oracle to MariaDB.
Hi,
Before we migrate from oracle to MariaDB DB we will do PoC and for the PoC we need to prepare…
Before we migrate from oracle to MariaDB DB we will do PoC and for the PoC we need to prepare…
Troubleshooting Solution
Urgent: ORACLE initialization or shutdown in progress
I can't log to Oracle database and I get this error message
ORACLE initialization or shutdown…
ORACLE initialization or shutdown…
Video
Connecting To SQL Server From Oracle Using Heterogeneous Services Generic Gateway
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic …
Article
How Oracle Stores Passwords
How Oracle Stores Passwords
Sean D. Stuber 2009-06-09
Up to date through Oracle version 11g
Explore solutions and more
![Oracle]()
Oracle DatabaseBack to the top
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.