Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
We can also display the execution plan with sqlplus. For this we can use the explain plan tool with sqlplus. To use the Explain …
Read More »How To Encrypt SQL Server Stored Procedures, Views and Functions
Stored procedures, functions, and views are objects that each application uses at the database tier. In some cases, it may be necessary to encrypt …
Read More »HAVING Clause in SQL Server and Difference Between WHERE Clause(TSQL)
HAVING Clause is used for filtering like WHERE Clause. The difference is that while WHERE Clause is filtering on ungrouped data, HAVING Clause filters on …
Read More »ORA-01426 numeric overflow Error When Trying to get backup with Expdp
When you try to get a backup with Expdp, if the process ends with error ORA-01426: numeric overflow, there are some alternative solutions. During …
Read More »How To Change Default Paths of the Data and Log Files
I explained in detail how to create a database in the article “How to Create a Database on SQL Server“. If you do not …
Read More »SEQUENCE in SQL Server(TSQL)
Sequence is a table-independent structure similar to the identity logic in SQL Server. You can use the sequence in more than one table. You …
Read More »ORA-01567 Error During Redo Log Group Drop Operation
If we are trying to drop the redo log group created for a thread that is active and if the drop operation of redo …
Read More »The certificate ‘xxx’ cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate)
You may need to delete the certificate that you created with TDE(Transparent Data Encryption) during the database encryption process. And during this deletion process, …
Read More »How To Concatenate Query Results in SQL Server(TSQL)
The other day I had to concatenate a query result. In this article, I’m going to tell you how to do this through an example. …
Read More »How To Delete the Last Character of a String in TSQL(DATALENGTH and LEFT Functions)
When developing code in TSQL, we may need to delete the last character of a string in some cases. The other day, I used the …
Read More »