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

The PIVOT , which is indispensable for Excel users, can be implemented with SQL Server 2005 via T-SQL. But I can’t say it’s as talented …

In this article, I will tell you to get the create script of an oracle user. First, we will create a file named user.sql that …

  You can find detailed information about Contained Database in the article “What is Contained Database” We can create a new Contained Database and create …

  When the catupgrd.sql is run during the manual upgrade process, it ends with “ORA-01722: invalid number” error due to the Database Vault configuration in …

  I would like to write this article because it is a topic that some friends who are interested in SQL Server are usually curious …

In some cases, we may need to determine the memory rates used by databases. Because some databases using extra memory may be degrading the performance …

PostgreSQL is a database management system that is bare when it is first installed. Therefore, you should make some configurations according to your system resorce. To …

We can read data from Oracle or MSSQL with the help of PostgreSQL Foreign Data Wrapper. Please read the following articles for installation and detailed …

Docker, which is becoming increasingly popular, is in the logic of virtualization. But unlike conventional known virtualization tools(Virtualbox, Vmvare ,kvm vb.. ), it does not …

  OUTPUT Clause transfers the records affected by the currently executed INSERT, UPDATE, or DELETE operations to the specified table. So we can easily capture …