You can use pgadmin or psql to connect to the PostgreSQL database. I do not prefer to do database administration with pgadmin. You can …
Read More »How To Connect To Oracle With Toad
To connect to Oracle with Toad, you need to download and install Toad. TNS Information You must write the tns information of the database you …
Read More »How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS)
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, …
Read More »How To Remove Database Target From oem
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 …
Read More »How To Create Database On PostgreSQL
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 …
Read More »Join Types in SQL Server
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 …
Read More »How To Create Oracle Profiles
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 …
Read More »send mail from linux using mailx
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 …
Read More »shell script to check disk space and send email alerts
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 …
Read More »What is Execution Plan in SQL Server
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 …
Read More »