Category: Database

Oracle “ORA-12162: TNS:net service name is incorrectly specified” Error and Solution

Posted on 11/12/201811/12/2018 by İsmail Baydan

During the connection to the Oracle Database server with the sqlplus we may get an error with the ORA-12162 specifier. This error will prevent to connect to the Oracle Database Server.

Oracle Database “sqlplus: error while loading shared libraries: libsqlplus.so” Error and Solution

Posted on 11/12/2018 by İsmail Baydan

sqlplus or sqlplus64 tools are used to connect and manage Oracle Databases. sqlplus64 is 64 bit version of the sqlplus. After installating these tools successfully when we try to run

How To Install Oracle Express Edition (XE) 18 On Linux?

Posted on 11/12/201811/12/2018 by İsmail Baydan

Oracle is very popular database which is used by big enterprises, banks, governments etc. Oracle Database provides a lot of useful features to the MS SQL, PostgreSQL, MySQL etc. Oracle

How To Create, Use and Delete SQL View?

Posted on 08/11/201823/12/2018 by İsmail Baydan

SQL Programming language and SQL Database engines provide some useful mechanisms in order to make management of the data easier. SQL View is one of them which can be used

How To Download And Install SQL Server Management Studio On Windows?

Posted on 08/11/201808/11/2018 by İsmail Baydan

SQL Server is a service running on Windows operating systems. In order to manage this SQL server service and instances with GUI we need to install Microsoft SQL Server Management

How To Download and Install MS SQL Server 2017 Express On Windows?

Posted on 07/11/201810/11/2018 by İsmail Baydan

Microsoft SQL Server is provided with different licenses. Free version is named Express Edition . Express Edition is very useful if we need a little database. Download We will download

Most Useful SQL Commands List with Examples

Posted on 17/09/201817/09/2018 by İsmail Baydan

SQL or Structured Query Language is a standard language used to to create, list, update, delete databases, tables, records. It provides this functionality with different type of commands. In this

SQL “Select Into” Statement Usage Tutorial

Posted on 01/09/201801/09/2018 by İsmail Baydan

SQL provides different statements in order to select into existing table, variable, temp table in various database servers like Oracle, MySQL, PostgreSQL etc. In this tutorial we will examine how

How To Create New User and Set, Grant Permissions To User In MySQL and MariaDB?

Posted on 16/08/201816/08/2018 by İsmail Baydan

MySQL provides ability to create and users from its shell. Security is important part of the database servers. In this tutorial we will examine how to create users and manage

How To Check and Determine MySQL Database Server Version?

Posted on 13/08/201813/08/2018 by İsmail Baydan

MySQL or MariaDB is very popular opensource databases servers. While using these database servers we may need to know the version of the client or server. We can use features