oracle

Oracle DROP USER Command with Examples

Oracle is one of the most popular relational database management systems famous for its flexibility and convenience for information management. You can easily adjust any Oracle database to meet your everyday requirements. Sometimes, it is necessary to delete particular users from your Oracle database. Basically, there are two ways of achieving this goal: by using the Oracle DROP USER command or with the help of an Oracle IDE allowing you to automate the process. This tutorial is valid for all Oracle versions starting from 11g-12c and ending with 19c.

(more…)

Oracle CREATE TABLE Command in PL/SQL with 10 Examples

In this article, we are going to talk about the CREATE TABLE command. To be more precise, we will focus on how to create a table in Oracle with a primary and foreign key, as well as not null and date columns, take a close look at how to create a new table on a basis of the existing one, and more. Also, we will review the perks and benefits of using dbForge Studio for Oracle when working with tables.

(more…)

Support for New Data Types and Other Improvements in dotConnect for Oracle 9.16

The new version of Devart dotConnect for Oracle contains improvement of Entity Framework Core: the support of new data types Uri, IPAddress, PhysicalAddress, and expanded ability to translate LINQ queries into SQL. Further, the support for Entity Framework Core Spatial Data functionality used to work with Oracle Spatial and Graph has expanded.

(more…)

Here Comes dbForge Studio 4.4 with the Updates You Don’t Want to Miss!

Meet the latest update of dbForge Studio for Oracle! It packs quite a punch that we believe you will find interesting: updated connectivity, a few new options in the Schema Compare functionality, several useful additions to Documenter, and a couple more improvements that will make dbForge Studio an even better tool for your daily tasks.

Without further ado, let’s have a detailed overview of these updates.

(more…)

How to Create New Oracle Database in 4 Different Ways

This article will describe the steps to create a database in Oracle: from the first preparation activities to using the Oracle CREATE DATABASE syntax. Here, you will find four ways to create a database in Oracle step by step. Two of them will be based on the command line: using the CREATE DATABASE command, as well as generating the CREATE DATABASE script from an existing DB. The other two will describe how to use such GUI utilities as DBCA, and Oracle SQL Developer. This tutorial is relevant for Oracle versions 12c, 11g, 10g, and higher.

(more…)

Update Your dbForge Tools to Prevent Diagram Control Errors

If you are using any dbForge tools for SQL Server, MySQL, Oracle, and/or PostgreSQL, please make sure you have read this post.

(more…)

Topping the Charts Again: dbForge Studios Awarded G2 High Performer & Leader Fall 2021

More good news coming our way!

It is inspiring to see that all the hard work we put into our products pays off as happy users and good reviews bring us more and more recognition on independent software reviewing platforms and marketplaces.

Today, the products in question are dbForge Studios for MySQL and Oracle, which have earned new badges in the Database Software category on G2.

(more…)

How to ADD, RENAME, MODIFY, and DROP Column, using the ALTER TABLE Statement in Oracle

In this article, we are going to talk about the ALTER TABLE statement and different ways to use it in Oracle. The syntax provided in this article will work for any version of Oracle as well as with SQL Server, MySQL, and PostgreSQL.

(more…)

Meet Updated dbForge Tools for Oracle with CLI Activation

We are delighted to announce the release of the updated dbForge tools for the Oracle, including dbForge Schema Compare, dbForge Data Compare, dbForge Data Generator, and dbForge Documenter.

(more…)

Discover dbForge Studio for Oracle v4.3 with CLI Activation

We are delighted to inform our Oracle users that a new dbForge Studio for Oracle, v4.3 has been just released.

(more…)

Your subscription could not be saved. Please try again.
Confirm your email by clicking the link in your inbox!

Subscribe to our blog

to get the latest posts delivered to your inbox