Tag Archives: plsql

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 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 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 …