Tag Archives: PL/SQL

I will explain dbms_output.put_line in PL/SQL in this post.

Hi Folks,   Datetime functions operate on date (DATE), timestamp (TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE), and interval (INTERVAL DAY TO SECOND, INTERVAL YEAR TO …

Hi Folks,   Functions are similar to operators in that they manipulate data items and return a result. Functions differ from operators in the format of their arguments. This format …

Hi folks,   In this post, I’m going to discuss 8 features that you must know to work with PL/SQL. These are structures that I have been using most in …

Hi folks,   A package is a schema object that groups logically related PL/SQL types, variables, constants, subprograms, cursors, and exceptions. A package always has a specification, which declares the public items that …

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 …