PL/SQL

Hi folks,   A user-defined function is a set of PL/SQL statements you can call by name. Functions are very similar to procedures, except that a function returns a value to …

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 …

Hi all in this article we continue with the flow operators in PL / SQL Programming. You can browse our previous article before moving on to this article PL/SQL Programing …

Hello, PL / SQL Programming articles continue. In my previous article, we talked about function, procedure blocks, and today we will look at character sets and data types. I recommend …

Hi, I continue to write PL / SQL. In the previous article, we have examined the simple block structure and made a small start, now we will continue with the …

Hi, I continue to PL / SQL articles. If you have not read the previous article, I recommend you to start there first. In this article we will introduce PL …