1. Overview In this document, we will explore a shell script named sftp_file_transfer.sh that automates the process of transferring files from one server to another.   2. Technologies [...]

  1.   Overview In this document, we will explore how to create a simple yet effective shell script to send email alerts with multiple attachments.   2.   Technologies and Tools Used [...]

Introduction Oracle provides you with two date time data types: DATE and TIMESTAMP for storing point-in-time data. In addition, it provides the INTERVAL data type that allows you to store periods [...]

Introduction The database’s SQL engine now supports a VALUES clause for many types of statements. This new clause allows for materializing rows of data on the fly by specifying them using [...]

Overview This document says about how to load multiple data files with csv format using sql loader from UNIX and also explains about control file and database connection through Linux. [...]

 Overview This document talks about how Qualified Expressions for Associative Array works before and after the oracle 18c version.  Technologies and Tools Used The following technologies has been [...]

Overview Inline external tables enable the run time definition of an external table to be part of a SQL statement, thus eliminating the need to create an external table as a persistent database [...]

Overview This topic provides examples of how to load CSV files from external tables under various conditions. Some of the examples build on previous examples. Technologies and Tools Used The [...]

Overview The LISTAGG aggregate function now supports duplicate elimination by using the new DISTINCT keyword. The LISTAGG aggregate function orders the rows for each group in a query according to [...]

  RETURNING Clause With EXECUTE IMMEDIATE 1. Overview The RETURNING clause allows you to retrieve values of columns (and expressions based on columns) that were modified by an insert, delete [...]