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

If you are using Linux and want to securely connect to servers without using a username password, you can create a ssh key and connect …

In this article, we will see how to create a user in Centos and how to grant root privileges to a user in Centos. How …

The article contains information about MYSQL IF Statement, ELSEIF Statement and ELSE STATEMENT used to direct the command flow by condition in the MySQL VTY …

What is a logical standby database? Apart from Physical and Snapshot Standby Database, it is another type of Standby Database. It is an active database …

In this article, we will talk about Neo4j backup and restore operations. Neo4j Offline Backup Let’s take Offline backup of Neo4j Graph Database. It is …

The article provides information about MySQL stored procedures. Creating a stored procedure and stored procedure types are explained with examples. What is MySQL Stored Procedures? …

After the STANDBY Database is installed and the necessary configurations were made, when INSTANCEs wanted to be START, one of the INSTANCEs opened and the …

The article contains information about LOCK TABLES in MySQL VTY system. Features added to the database during database design or later (INDEX, Foreign Key, UNIQUE …

The index scans are the table access paths used by the oracle optimizer to generate the best execution plan. There are different types of scans …

We will explain Oracle PDB Automatic Startup in 12c in this article. STEP 1 :-  Check The List Of PDBS . Here In My case …