Oracle Database: How to check if the table has a primary key. Types of constraints
A constraint is a rule that you define and its task is to protect the table from clutter that may arise as a result of adding incorrect or incomplete data.…
Oracle database: How can I change a user's password using Oracle SQL Developer?
We can change the password in at least two ways, using: SQL syntaxUsing Oracle SQL Developer software. Method 1 alter user user_name identified by you_new_password replace old_password; Method 2 Using…
How to install Oracle SQL Developer on Ubuntu 18.04?
In this short post I will show you how to install Oracle SQL Developer on Ubuntu 18.04. Download the latest version of Oracle SQL Developer from the official Oracle website.Select…
SQL Developer: How to restore / add the Connections tab in SQL Developer?
If you have been using SQL Developer for some time, you have probably encountered the situation that you accidentally or for various reasons closed the Connections tab. However, how to…
Photo by Campaign Creators on Unsplash
SQL Developer: How to connect to the Teradata / MS SQL Server database in Oracle SQL Developer?
Oracle SQL Developer provides the feature to connect to many databases, including to Teradata, Microsoft SQL Server, IBM DB2, Sybase, MySQL and even Microsoft Access. All you need is the…