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
  • 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

Article

Setting Up Oracle 23c Using Vagrant-Projects

In this article we will see to setup Oracle 23c free developer version using Vagrant project and the new features include on this version.
Article

Identity and Access Management

In this article we will see how Identity and Access Management plays a key role any enterprise-level database management system.
Article

New SQL features on Oracle 21c Database

In this article we will see what new features are been release by Oracle for making SQL much efficient .
Article

Simple PL/SQL Block to Identify Potential Performance Problem for a SQL

In this article, we'll create a simple PL/SQL block to identify potential performance problem for given SQL statement.
Article

JSON In Oracle Database

In this article, we'll take a closer look at JSON in Oracle SQL and how you can use it in your applications.
Article

Ways To Load Large Tables In Oracle

In this article, we will see the options and faster ways to load large tables in Oracle database.
Article

Table data compression, a multi-valuable database feature.

Data compression is a feature offered by many modern databases like Db2, Oracle, MySQL, MariaDB and SQLServer. However, many companies do not use this feature in their database systems. Either they lack the knowledge of its existence in the application/systems design phase or due to budget issues.
Article

PowerSchool ODBC

PowerSchool SIS ODBC
Article

Advice on Career Growth from Oracle Certified Experts

In this article, we are 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

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

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

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

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

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

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

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

Partition By Clause in Oracle

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.

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

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

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.

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more