Category: Oracle

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. “ORA-12162: TNS:net service name is incorrectly specified” Error This error

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 sqlplus command we may get an shared object file or

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 Express is lightweight database server provided by Oracle. We can

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 to create a table from a SQL result set. What

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 tutorial we will learn popular and useful SQL commands. Command

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 to use Select Into SQL statement for different cases. Syntax Select

How To Prevent SQL Injection in Php Applications?

Posted on 03/11/201620/11/2018 by İsmail Baydan

I have an application and I have complex requests tot the server. There are a lot of database operations. Managing them can become very hard some times. In this situation how can I prevent sql injection attacks to my application.

What is The Difference Between Inner and Outer Join?

Posted on 16/10/201617/11/2018 by İsmail Baydan

Sql is the language where a lot of data can be get with different logic. In an enterprise environment we may need to use complex SQL queries to get meaningful data. Inner is one of the logic where we join