Oracle

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 …

I will share with you Step by Step Performance Tuning and SQL Tuning Tutorial in the Oracle Database in this article.

Hi, I will explain how to solve ” ORA-01578: ORACLE data block corrupted (file # string, block # string) ” error.

I will explain How to Grant and Revoke Privileges in Oracle Database in this post. Let’s review the Grant and Revoke Privileges in Oracle.

Hi, I will explain How to Setup Passwordless SSH User Equivalence ( (Key-Based Authentication) ) for Cluster Nodes ( Servers ) in this post.