Oracle SQL

Hi folks,   A procedure is a subprogram that performs a specific action. This feature is extremely important and vastly that we can use when developing in PL/SQL. Before invoking …

Hi there,   One of the most used features of PL/SQL is the exception handling. Exceptions can arise from many different sources such as coding mistakes and design faults. Although …

Hi there,   Well, cursors are widely used when programming in PL/SQL, so it is better to master it. In this article, I’m going to cover the basic structure for …

Hi,   Other structures when programming in PL/SQL are the FOR LOOP and CURSOR. In this post, I’m going to show how to use both of them together. Well, there …

Hi,   PL/SQL is a block-structured language whose code is organized into blocks. A PL/SQL block consists of three sections, declaration (non-required), executable (required), and exception-handling (non-required) sections. All kinds …

I will explain Bulk Insert and Bulk Update in Oracle Database in this article.

Hi everyone, in this tutorial we will look the Date functions.  Date functions in SQL Language are given below.     ADD_MONTHS Function Used to add months to the date …

Hi everyone, we continue with the topic of functions. You can read the previous functions article here.   Raund Function Used to round the numeric values that result from a …

Hi everyone, In this article we will examine Functions. In SQL Language, instead of repeating the same tasks, writing these functions as functions saves you time and makes your queries …

Hi everyone, In this article, we will examine the conditional clause “WHERE” and logical operators. In the SQL language, if you want to show the output of the SQL command …