ORACLE

This article contains information about PL/SQL Loops such as WHILE, FOR and necessary statements for these loops like GOTO, Continue, EXIT. What is loop in PL SQL? PL/SQL Loops are …

This article contins information about PL/SQL Conditional Statements such as IF,IF ELSE,ELSEIF,CASE. Conditional statements allow to execute commands according to a certain condition. The condition in conditional statements is created …

This PL/SQL Tutorial is about PL/SQL Operators. Operators are special expressions that operate process between one or more values ​​in programming languages. PL/SQL has operators that allow to process various …

This article contains information about PL/SQL Data Types and Variables and Literals. Oracle PL/SQL Data Types Data types indicate how data is stored in memory. PL / SQL has several …

This article contains informations about Oracle Blockchain Tables and benefits. You will also find information about creating oracle blockchain tables and insert into data to it. Blockchain is a technology …

Sometimes we may need to take a datafile offline and online in oracle. In this article we will take a look at these operations and examine recovering data file after …

If a database created as Physical Standby is converted to a Logical Standby database while the Broker configuration is enabled, you may receive an error as follows. ORA-16674: standby database …

Sometimes, we may not want to reflect the operations performed on the Primary database to the Logical Standby database. It can be ensured that DML operations performed in Primary are …

To delete archive logs automatically on standby you should set LOG_AUTO_DEL_RETENTION_TARGET  parameter. The Foreign Archive Logs in Logical Standby Database is automatically deleted by SQL Apply after the time specified …

Below are some of the basic hygiene techniques and concepts we should keep in mind to get the maximum performance out of our query . We should always add adequate …