Category: Tutorial

In computerized information systems, data is the basic resource of the organization. So, proper organization and management of data are required for an organization to run smoothly. The Database management system deals with the knowledge of how data is stored and managed on a computerized information system. Any organization, requires accurate and reliable data for…

This Oracle tutorial teaches you how to use SQL to interact with the Oracle database. You will learn various techniques to query data from the database and how to manage database tables such as creating, modifying, and deleting tables, as well as advanced concepts like Views, Functions, Stored Procedures, Triggers, Transaction Management, etc. Introduction: In…

There are no prerequisites to learning Oracle SQL and it is easier to learn but make sure before learning Oracle, you must have a basic knowledge of computer fundamentals. It’s a query language with an English-like language. So, anyone who can use English at a basic level can learn and write SQL queries easily. The…

This section covers the common Oracle Database administration tasks.  If you are an Oracle Database Administrator who wants to get grips with Oracle quickly and effectively, then this section is for you. This Oracle Database administration section is also highly beneficial if you are a developer or project leader who is interested in knowing more…

This tutorial provides you the most commonly used Oracle string functions that help you manipulate character strings more effectively. Function Example Result Purpose ASCII ASCII(‘A’) 65 Returns an ASCII code value of a character. CHR CHR(’65’) ‘A’ Converts a numeric value to its corresponding ASCII character. CONCAT CONCAT(‘A’,’BC’) ‘ABC’ Concatenate two strings and return the…

This page provides you with the most commonly used Oracle date functions that help you handle date and time data easily and more effectively. Function Example Result Description ADD_MONTHS ADD_MONTHS( DATE ‘2016-02-29’, 1 )  31-MAR-16 Add a number of months (n) to a date and return the same day which is n of months away.…

Oracle analytic functions calculate an aggregate value based on a group of rows and return multiple rows for each group. Name Description CUME_DIST Calculate the cumulative distribution of a value in a set of values DENSE_RANK Calculate the rank of a row in an ordered set of rows with no gaps in rank values. FIRST_VALUE…

Introduction to Oracle aggregate functions Oracle aggregate functions calculate on a group of rows and return a single value for each group. We commonly use the aggregate functions together with the GROUP BY clause. The GROUP BY clause divides the rows into groups and an aggregate function calculates and returns a single result for each group. If you use…

If you’re a developer or a database administrator looking for a way to master PL/SQL programming language, these PL/SQL tutorial series are for you. These PL/SQL tutorial series contain the information that every developer and database administrator should have to efficiently use PL/SQL in their daily tasks. As you go through the entire tutorial series,…

Oracle index is one of the effective tools for boost the query performance. However, in order to use it effectively, you must understand it correctly. This section helps you understand and use Oracle indexes to speed up your queries.