Oracle Articles Examples, Tutorials and Articles

Introduction

Value Set is a collection of values. It validates the values entered by the user for a flex-field, report parameters or a concurrent.

The navigation path: Application :- Validation :- Sets

Value Set is associated with the following validations which ...

1. Introduction

In the last article, we simulated the attack of simulation of SQL Injection in Oracle. In the current article, we shall see the remedies of SQL Injection, code recommendations, and guidelines to avoid malicious attack on applications.

2. Using invoker’s ...

1. Overview

The article describes the SQL injection attacks on applications. It demonstrates the code exploitation, ways of rectification and code designing recommendations.

2. Introduction

SQL injection refers to the attack on the applications which have ...

1. Introduction

Oracle provides Export and Import utilities for the transfer of data from one database to another. It enables writing of data i.e. Export of one database into Operating system files in binary format. These OS files in binary format can only be traced by IMPORT utility ...

1. Overview

In the last article, we saw through the stages involved in a Database design. These stages were the categories where the effort involved can be modularised and cumulatively integrated at start of each stage.

Now there are other logical concepts required in logical ...

1. Overview of Database Design basics

An application skeleton consists of Data and Process. Both are mutually dependent on each other. Even a slightest weakness in any of the two can end up in application defects. In the article, we shall discuss the Data side of an application. We shall ...

1. Introduction

VARRAY is the third form of collection available in Oracle, which stands for “Variable sized Arrays”. It is ordered set of fixed number of homogeneous elements, which is available in both SQL and PL/SQL. They can be physically stored in database as schema objects. ...

1. Overview

A collection is a group of elements arranged in a defined order, where each one of them can be accessed through its index. The most common forms of collections are arrays, maps or lists. In current version of programming languages, almost all of them support the use of collections. ...

1. Introduction

Nested Tables or PL/SQL tables are persistent form of collections, which are used to store arbitrary number of elements. Unlike the key-value pair, here each element is identified by a sequential number, which is maintained by Oracle server.


The ...