oracle

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

What Is a Database?

The article provides a general overview of the databases in simple terms, discusses their advantages and drawbacks, and covers the types of data to be used in databases to better understand and more effectively organize your databases.

(more…)

Introduction to ADO.NET

ADO.NET is a part of .NET Framework that provides access to different types of data sources. ADO.NET supports relational, XML and application data. ADO.NET resides in a layer between data sources and client applications and enables customers to retrieve, manipulate and update data through ADO.NET object model.

(more…)

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