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 and…
Read More1. 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…
Read MoreIntroduction 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 of time. There are…
Read MoreIntroduction 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…
Read MoreOverview 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.…
Read MoreOverview 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 used to…
Read MoreOverview 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…
Read MoreOverview 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…
Read MoreOverview 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…
Read MoreRETURNING 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…
Read More