Nothing but my learning and experience with Oracle..!

Physical vs logical standby database in oracle  The Data Guard Configuration consists of one Production database and upto nine Standby d...

what is the use of bind variable in oracle  Each time an SQL statement is sent to the database, an exact text match is performed to see if...

Batch file for taking cold backup and expdp In many case we need to take the cold backup , am happy to share this batch file that will   ...

Package in oracle with example A package is a group of procedures, functions, variables and sql  statements created as a single unit. It ...

Programming Oracle with PL/SQL - Learn About Procedure and Function in Oracle with example A PL_SQL Block are broadly divided into two cat...

Learn About Different Type Of Triggers In Oracle Database triggers are specialized stored programs. Oracle engine allow the definition ...