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

In today’s article we will learn How to See Active Session in Oracle Database. With the help of the code block below, we can see …

In today’s article, we will learn about integer data types and the last values they will take in the range section. These values are given …

We can monitor the status of an export/import operation running in the background by attaching it with the ATTACH parameter. For this, we first need …

In today’s article, How Can I See Invalid Object in Oracle Database? I will be answering the question. We can see with the help of …

In today’s article, I will talk about PostgreSQL Data types to give general information and to meet our basic needs. In database operations, there are …

This error can occur if the Oracle open_cursors parameter is too low or there is a coding issue where sql statements are not closed. [crayon-673ed3e726d68642662986/] …

In today’s article we will learn PostgreSQL Local Database Settings (LC_COLLATE, LC_CTYPE). First, What is Encoding? Let’s start with this. Encoding: Encoding is the character …

With the SQLFILE parameter, it provides us with the sql statements that import operations run. [crayon-673ed3e727026824687445/] Afterwards, you can see which commands are available by …

When i tried to connect to database, I got the ORA-00020: maximum number of processes (%s) exceeded error. Even from sysdba I was not able …

When creating new projects and new databases, we can use the template0 database instead of writing one by one. Example: [crayon-673ed3e7272af038715621/] We can create it …