Oracle SQL

Hi, I will explain Introduction to Oracle SQL in this post of Oracle SQL Tutorial series.

Hi, I will explain Create Synonym Tips in Oracle with Examples in this post.

I will explain Alter Session Set NLS_DATE_FORMAT in Oracle with Examples 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,   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 …

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 …