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

We can find oracle service name with two method. TNS information is required to connect to Oracle. In the service_name parameter in the TNS information, …

In this article we will see how to remove a database from oem. You should remove deleted databases from oem. First connect to oem and …

You can create database on PostgreSQL easily. You can specify some parameters when creating database. If you want more about Postgresql you may want to …

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 …