To create a user in PostgreSQL, we first connect to PostgreSQL. To connect to PostgreSQL You can read the article named “How To Connect To …
Read More »dbtut
JOIN Types In SQL Server Execution Plan
In this article, we will examine the join types in the execution plan. Before you read this article, you can get more from this …
Read More »How To Create a Table and List All Tables On PostgreSQL
You can use the following commands to create tables in PostgreSQL Databases and to list all the tables in the database. CREATE TABLE …
Read More »How To Connect To Database On PostgreSQL
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 »