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

Article

Advice on Career Growth from Oracle Certified Experts

byExperts Exchange
In this article, we’re highlighting the methods that three of our Oracle Certified Experts used to make their way in the Oracle world. Learn how to start in IT, how to grow your career in Oracle, and where the industry is going in the next five years.
Article

Dynamic Version Controlling of Oracle Metadata using shell script

bySwadhin Ray
In this article, we will see how we can automate the process of moving Oracle metadata to version control system, in my case I am using GIT using a simple shell script to avoid manual intervention.
Article
Converting BYTES to CHAR on Oracle Database

Converting BYTES to CHAR on Oracle database

bySwadhin Ray
In this article, I will be sharing the issues that we faced while converting the data type and NLS semantic to CHAR from BYTES. This was one of the business use cases where we needed to convert the entire columns throughout the schema from BYTES to CHAR types only for VARCHAR2 columns datatypes.
Article

Using FIRST_VALUE & LAST_VALUE in Oracle Analytic Functions

bySwadhin Ray
In this article, we will see how to use FIRST_VALUE & LAST_VALUE in Oracle with simple examples.
Article
How to fix OLE DB connection error while connecting Oracle database using SSIS

How to fix OLE DB connection error while connecting Oracle database using SSIS

bySwadhin Ray
In this article, we will see how we can fix the OLE DB connection error when connecting to an Oracle database using SQL Server Integration Services.
Article

Introduction to Rank Function in Oracle

bySwadhin Ray
In this article, we will see how to use the RANK analytical function in an Oracle database and how it helps us in an analysis.
Article
Order by Clause in Oracle Analytic Functions

Order by Clause in Oracle Analytic Functions

bySwadhin Ray
In this article, we will see how to use Order by Clause in Oracle with simple examples.
Article
Oracle 12.2.0.1 -

ORA-12547: TNS:lost contact - "sqlplus / as sysdba" - Oracle 12.2.0.1

byAbhimanyu Suri
1
ORA-12547: TNS:lost contact, "sqlplus / as sysdba"
Article
Partition By Clause in Oracle -

Partition By Clause in Oracle

bySwadhin Ray
An introductory discussion about how to use Partition by Clause in Oracle.
Article
Reverse path filtering setting between RHEL 5 vs RHEL 7

Reverse path filtering setting between RHEL 5 vs RHEL 7.

byChakravarthi Ayyala
This is about the change in the value setting for the rp_filter parameter in Linux.
Article
Introduction to Analytic Functions in Oracle

Introduction to Analytic Functions in Oracle

bySwadhin Ray
An introductory discussion about Oracle Analytic Functions which are used to calculate or compute Aggregate values, based on a group of rows.
Article
Using full redaction for masking the column values in 12c -

Using full redaction for masking the column values in 12c

bySwadhin Ray
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
Article

Script to backup Dataguard broker configuration

byAbhimanyu Suri
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Article
Data center

Five Myths of Oracle Database Backup

byAcronis
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Article

Some Useful Settings in JasperReports Server

byDoug Walton
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Article
SQL Scripts

Using SQL Scripts in Oracle Application Express

bySwadhin Ray
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Article
SQL Command Tool

Introduction to SQL Command Tool in Oracle APEX

bySwadhin Ray
SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database objects which can later be used in our application.
Article

Introduction to Oracle APEX SQL Workshop- The object browser

bySwadhin Ray
3
APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
Article

Meta Characters in Oracle

bySwadhin Ray
Meta characters are the characters in a programming language that are interpreted by the programming language to have specific meanings within the language itself.
Article

Composite Queries in Oracle

bySwadhin Ray
1
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more