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
Software Developer
A person who never made a mistake never tried anything new.
- Albert Einstein
FORTIS FORTUNA ADIUVAT
SI VIS PACEM PARA BELLUM
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 …
Troubleshooting Solution
how to compare 2 comma seperated strings in oracle sql
I want to write a sql or pl/sql function anything. My moto is to compare 2 comma seperated strings.
…
Troubleshooting Solution
Convert output of query from utc time to cst time
The INCOMING_HEARTBEAT_TS column is in UTC time and so the output of the query is in utc time. I
…
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
Oracle to Access --ODBC error
I am creating an ODBC from an ORACLE database to an Access database. The ODBC checks ok in control
…
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 …
Troubleshooting Solution
What are better SQL options than "IN ( 'value1', 'value2', 'value3)"
I have a major performance problem with "IN".
What are my options?
I would need to put 10K-20K items
…
Research Solution
the way to downsize Oracle database to MySQL
Hi,
Right now we want to have wish that we try to downsize Oracle database to MySQL, as far as I
…
Troubleshooting Solution
How setup multiple Oracle DBA_accounts
Hi
If you have a few Oracle DBAs doing adminsitration for Oracle Server 19c on RHEL 7, is it normal
…
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 …
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
Extract Value based on Delimiter
Hello Experts,
Can someone please help me parse specific data from the URL below using SQL? Here is
…
Troubleshooting Solution
oracle 19c database on windows server 2019, unable to connect via tns/sql developer.
i have windows server 2019 standard and oracle 19c databases installed on it. All the other
…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.