Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

In today’s article we will be learning how to add a Redo Log Group in oracle database. Groups, members and dimensions should be checked before …

In today’s article, we will examine what we need to pay attention to when performing Critical Authority Controls in Oracle Database. The most critical authorizations …

In today’s article, we will be using the concept of Natural Join to join relational tables together. Unlike others, Natural Join finds the relationships between …

In today’s article we will be learning how to Drop Redo Log Group In Oracle. Before dropping a group, note that it is “INACTIVE”. [crayon-67ff5d5ebcaf5974896533/] …

In today’s article, we will be learning how to list which user has which privileges on Oracle Database. For this we will use the following …

In today’s article, I will be explaining FULL OUTER JOIN, which is the combined version of LEFT OUTER and RIGHT OUTER JOIN in PostgreSQL. In …

In today’s article, we will be learning how to Delete Redo Log Member in oracle. When deleting a member from a group, we must check …

In today’s article, I will be explaining how to partition a classic table online without interruption for Oracle Database. In our work, as usual, we …

In today’s article, we will explain the general use of PostgreSQL Cross Join with examples. PostgreSQL Cross Join returns cartesian product of Tables. That is, …

In today’s article we will be learning how to Move Redo Log File in oracle database. Moving Redo Log files with the database open is …