A database in working is actually a set of operating system files that contain the user data and the metadata. Every instance of the running Oracle database is associated with a set of background processes or threads and a shared memory. Now, an instance can open at most one database at a time but a Continue reading

Analytic functions are also called the windowing functions and have been introduced in Oracle 8i. These functions, unlike the aggregate functions, do not reduce the number of rows returned, however, just like aggregate functions they also operate on a set of rows. This time we are looking at two of the analytics functions – LEAD Continue reading