PL/SQL

I will explain UTL_FILE FOPEN in PL/SQL in this post.

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

I will explain Alter Session Set NLS_DATE_FORMAT in Oracle with Examples in this post.

Hi Folks,   Conversion functions convert a value from one datatype to another. Generally, the form of the function names follows the convention datatype TO datatype. The NULL-related functions facilitate …

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,   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,   Object-oriented programming is especially suited for building reusable components and complex applications. In PL/SQL, object-oriented programming is based on object types. They let you model real-world objects, …

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 …