Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

We can combine more than one table through equi-columns in tables and perform joins in a single result set. There are a few kinds of …

We will create oracle profile and explain with all details. What are Oracle SQL Profiles? Oracle Profiles allow us to manage users according to certain …

This article contains information about send mail from linux using mailx, mailx linux installation, configure mailx. First of all, the server you want to send …

This article contain infromation about shell script to check disk space and send email alerts in linux. I wrote this article for regularly checking the …

What is a execution plan in SQL? Execution plan is a road map that determines how the query will work. Will the query use the …

What is Crontab? If you want to perform regular operations(for example schedule a task) on Linux, you should create a cron job. Create a Crontab …

What is Unique Constraint in SQL Server? The Unique Constraint guarantees the uniqueness of the colum or column on the table. It can be created …

If you are reading this article, you should read my articles “What is Primary Key And Foreign Key” and “What is Unique Constraint” at first. …

We will change user profile in Oracle in this article. Its very easy and simple step. Profiles allow us to manage users according to certain …

Difference Between Primary Key and Foreign Key You can be find what is Primary Key and Foreign Key and what are differences between Primary Key …