SQL databases provide structured data storage capabilities. We can store data in tables with columns and rows. Other useful features for SQL databases are update capabilities. We can update SQL databases data in different ways and constraints. In this tutorial, we will learn how to update database table data with an SQL UPDATE statement and query single record, multiple records or conditional situations with examples. SQL UPDATE Syntax SQL Update...
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 will be look like below. This error is caused by not setting $ORACLE_HOME and $ORACLE_SID environment variables for Linux and Windows Operating systems. Check $ORACLE_HOME Environment Variable $ORACLE_HOME is important...
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 library error. sqlplus Shared Library Error sqlplus command shared library error full definition is like below. Keep in mind that for 64 bit version it will be sqlplus64
|
1 2 |
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory |
Print...
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 use Oracle Express Edition without a fee. Oracle Express Edition is named as Oracle XE . Download Oracle can be installed into Linux and Unix based operating systems. It is...
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 Is SQL View? SQL View is a virtual table which does not exist in a database physically. SQL View table is created from an SQL statement which is generally a...
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 Types SQL language is very advanced language which provides large command set. The commands are categorized according to their usage. Here is types of SQL commands. DDL – Database Definition...
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 Into statement syntax is the same as with Select syntax. We just need to a INTO between SELECT and FROM. We can also use WHERE statement in order to filter rows.
|
1 |
SELECT columns INTO newtable [IN externaldb] FROM oldtable WHERE condition; |
...
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. Use Prepared Statements Prepared statements are the way to bind client-side provided values with database queries. Prepared Data Object (PDO) acts middle proxy and prevents SQL injections. PDO is supported...
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 two tables with different magic. Example Tables In order to understand Inner and Outer Joins we will use following example tables with their data. We will use two tables those...
