Oracle

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 enables them to operate on zero, one, two, or more arguments. SQL functions are built into Oracle Database and are …

Hi, Sometimes You can get “ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE ” error.  362 views last month,  2 views today

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 enables them to operate on zero, one, two, or more arguments. SQL functions are built into Oracle Database and are …

Hi, I will share with you Step by Step Oracle Database Tutorials for Senior Oracle DBA.  4,924 views last month,  1 views today

Hi, I will explain How to Clear ILOM FMA Faults And Reset The SP on Exadata or Other Servers in this post.  5,001 views last month,  103 views today

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 my years of experience with Oracle. I know that there is a tremendous amount of important peculiarities when discussing PL/SQL. …

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, separate interfaces and implementation details, and store object-oriented data persistently in the database. An object type is a user-defined composite datatype representing …

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 can be referenced from outside the package.  If the public items include cursors or subprograms, then the package must also …

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 the environment in which it is called.   Syntax CREATE OR REPLACE FUNCTION <name> (<paramete1_name parameter1_type, .. ,parametern_name parametern_type>) RETURN …

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 a procedure, you must declare and define it. You can either declare it first (with procedure_declaration) and then define it later …

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 we can’t predict all failures that might happen, we can use exception handlers predefined in our programs or create our …

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 explicit cursors in FOR LOOP statement.   Basically, these cursors have to be declared with a SELECT statement in the …

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 are plenty of ways to create a loop in PL/SQL, one of the most common using an implicit cursor. This …

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 of structures that a developer might create in PL/SQL such as procedures, functions, packages, and types are based on this …

Hi, I will share with you Step by Step Performance Tuning and SQL Tuning Tutorial in the Oracle Database in this article.  9,539 views last month,  92 views today

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

Hi, You can get ” ORA-02080: database link is in use ” error during the drop any user.  606 views last month,  2 views today

Hi, I will explain How to Grant and Revoke Privileges in Oracle Database in this post.  732 views last month,  2 views today

Hi, Sometimes you can get ” ORA-01081: cannot start already-running ORACLE – shut it down first ” error.  357 views last month,  2 views today

Hi, I will explain How to Setup Passwordless SSH User Equivalence ( (Key-Based Authentication) ) for Cluster Nodes ( Servers ) in this post.  2,188 views last month,  46 views today

Hi, I will explain What is the SQL Performance Analyzer and SPA Report in this article.  641 views last month,  2 views today

ORA-00131: network protocol does not support registration ‘string’ Cause: The specified protocol does not support async notification. Action: Refer to the manual for information on supported network protocols.    170 views last month,  3 views today

Hi, I will explain What is the SRVCTL and Useful SRVCTL Commands in Oracle RAC in this post.  1,586 views last month,  14 views today