oracle tools

Oracle Tablespace – an Overview of Types and Basic Manipulations

In 2022, Oracle is still the world’s most popular database management system, and it is not going to lose its position anytime soon. Learning Oracle is obligatory for database specialists because chances are sky-high that you will have to develop and administer an Oracle database at some point in your career. In this article, we will explore one of Oracle’s distinctive features – tablespaces. dbForge Studio for Oracle with a whole set of convenient and user-friendly tools will help us throughout this journey.

(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…)

One More Achievement in the New Year: dbForge Studio for Oracle Got Two G2 Badges

We are excited to announce that dbForge Studio for Oracle won two G2 badges, which further prove how valuable it is to our users. And indeed, the G2 reviewers say that dbForge Studio is so convenient and versatile that they can’t imagine working without it.

(more…)

Meet Updated dbForge Tools for Oracle

The Devart team worked hard and now we are glad to introduce new features and improvements to one of our remarkable product lines – dbForge tools for Oracle, namely dbForge Data Compare, Documenter, Data Generator, and Schema Compare.

(more…)

Handle Concurrency Conflicts in ASP.NET Core and Oracle

Concurrency conflicts arise due to concurrent access to a shared resource. This article explores ways to handle concurrency conflicts using ASP.NET Core and Oracle. To connect to Oracle, dotConnect for Oracle will be used.

(more…)

Software Development Life Cycle Tutorial with Examples

SDLC (Software Development Life Cycle) is a series of steps for developing, improving, and sustaining a software system. Learn more about the stages and best practices. 

(more…)

dbForge Product Line Is Ready for Windows 11

Following our recent announcement that dbForge tools for SQL Server were updated and tested for seamless work on Windows 11, we hurry to make the same statement regarding our tools for MySQL, Oracle, and PostgreSQL databases. Now the entire dbForge product line is ready to accompany your database development and administration on the latest Windows OS.

(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 dbForge Fusion for Oracle, v3.10 with Fresh Connectivity Options

We are delighted to share the great news with our Oracle users – a new version of our Visual Studio plugin for Oracle database management, dbForge Fusion for Oracle, v3.10, has been just released!

(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…)