Linux, Windows, Security, Programming, Network Tutorials
The server is a computers type which consists of purposeful hardware and software used to provide different services to the clients. Servers generally use different and special applications to provide services. A server can contain a single service or multiple
Continue reading
MySQL or MariaDB database servers can be managed in different ways. Generally, GUI tools are provided because of their easiness. But in some cases command line connection may be required to connect and management MySQL and MariaDB database server. Install
Continue reading
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. “ORA-12162: TNS:net service name is incorrectly specified” Error This error
Continue reading
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 sqlplus command we may get an shared object file or
Continue reading
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 Express is lightweight database server provided by Oracle. We can
Continue reading
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 to create a table from a SQL result set. What
Continue reading
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 Studio. Download Microsoft SQL Server Management Studio We will download
Continue reading
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 the SQL Server 2017 Express Edition from following link which
Continue reading
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 tutorial we will learn popular and useful SQL commands. Command
Continue reading
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 to use Select Into SQL statement for different cases. Syntax Select
Continue reading
