Monday, May 29, 2023

Oracle

Complete Guide to Oracle ALTER SESSION

In this article, we will dive into the intricacies of ALTER SESSION, exploring its syntax, usage scenarios, and the wide range of settings it can manipulate. We will examine how this command can enhance query performance, control session-specific behavior, and streamline database operations.

Champs Recap: Award-Winning dbForge Database Solutions in Q1 2023

Now that Q1 2023 is over, it's time to deliver our traditional champs recap and showcase the awards and badges garnered by dbForge solutions on independent review platforms over this period.

Build Credit Card Analytics with Python using Devart ODBC for Oracle

This tutorial explain how to build the Credit Card Analytics using Python and Devart ODBC Driver for Oracle.

How to Connect Power BI to Oracle Database: The Definitive Guide

Learn how to easily connect Power BI to your Oracle Database with our comprehensive guide. Unlock the full potential of your data insights today!

Meet dbForge Edge, Your Ultimate Multidatabase Solution!

If you are a database developer dealing with several projects, it means you have to handle a number of database management systems simultaneously. And for each of these systems, you need to have a proper set of tools at hand. Moreover, the said set of tools must be complete and flexible enough to follow the evolving project and its current requirements.

Guide to Effective Date Formatting in Oracle

Dates are fundamental to many database applications, and correctly formatting them is crucial for ensuring data accuracy and efficient data retrieval. Oracle provides a plethora of date functions and formatting options to choose from, which can be overwhelming without proper guidance.

TRUNCATE TABLE in SQL

The article will overview the TRUNCATE TABLE statement in SQL on particular examples and describe the differences between the TRUNCATE, DELETE, and DROP statements. When...

Build Credit Card Analytics with Oracle Autonomous Database using Devart ODBC for Oracle

This tutorial explain how to build the Credit Card Analytics using Power BI and Devart ODBC Driver for Oracle.

Finden Sie ungültige Objekte in Ihren Datenbanken

DBA hat eine Reihe von Aufgaben, die hauptsächlich darauf abzielen, die Datenbank-Performance und die Datenkonsistenz zu unterstützen. Der Administrator kann den CHECKDB-Befehl verwenden, um...

Oracle Index: CREATE, DROP, RENAME – Guide with Examples

In Oracle, an index is a database object that creates and stores records for all values in specific columns or clusters. With the help...

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...

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...

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...

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...

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...

Create a New Oracle User and Grant Privileges: Syntax and Examples

In this article, we will talk about how to create a user in Oracle. You will learn how to add new database users, figure...

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...

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...

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....

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. Recently, Microsoft released...

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...

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...

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,...

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. The major improvements introduced...

SSL and SSH Support for Direct Oracle Connections in Excel Add-ins 2.5

Devart is glad to announce the release of Excel Add-ins 2.5 with support for secure SSL and SSH connections to Oracle in the Direct...

SSH Support in SSIS Components 1.14 and dotConnect for Oracle 9.12

Devart is glad to announce support of SSH connections in the Direct mode in dotConnect for Oracle 9.12 and SSIS Data Flow Components...

Connectivity to Oracle 20c is supported in dbForge for Oracle tools

We are glad to inform our Oracle users, that the new versions of dbForge for Oracle tools have been just released. The new versions of...

New Versions of ODBC Drivers: Oracle, PostgreSQL, QuickBooks, xBase

New versions of ODBC drivers for Oracle, PostgreSQL, QuickBooks were released with improved compatibility with Power Pivot, Visual Basic, and RStudio. The compatibility with...

Migrating Data From Oracle to PostgreSQL

In the article, you will learn how to migrate table data from Oracle to PostgreSQL using the dbForge tools.

Data migration from MySQL to Oracle server

Data migration is a tiresome task requiring a great deal of manual activity. In this article, we will examine how to migrate MySQL data...

New Features in dotConnect for Oracle 9.11

Devart is glad to announce the new version of our ADO.NET provider for Oracle with advanced ORM support - dotConnect for Oracle 9.11....

Entity Framework 6.3 and .NET Core 3 Support

.NET Core 3 .NET Core was presented by Microsoft in 2016, but its 1.x versions had limited set of features comparing to Full .NET Framework....

Generating subscription statistics data in Oracle Data Generator

When you need to fill your databases with data for testing purposes, it’s usually quite handy to also have this data follow dynamic patterns...

How to Connect Oracle Autonomous with Oracle Client

Oracle Autonomous Database is a powerful technology that provides data processing and management in the cloud for self-driving, self-securing and self-repairing databases which can...

Achieve Enterprise-level Productivity with dbForge Studio for Oracle!

We are thrilled to inform our Oracle users that dbForge Studio for Oracle got a really massive update that took database development and presentation...

New Look and Feel of Compare Bundle for Oracle

We are glad to announce the release of the updated dbForge Compare Bundle for Oracle. The tools of the Bundle, dbForge Schema Compare for...

Create Unique Generators with dbForge Data Generator 2.0!

We are glad to notify our users that a new version of the Devart Oracle data generation tool has been released - dbForge Data...

Keep Calm and Document Oracle Databases

We are thrilled to inform that our dbForge for Oracle product line has been expanded with a brand new tool for smart and easy...

JSON Support in Entity Framework v4 – v6 in dotConnect for Oracle, MySQL, and PostgreSQL

Recent versions of MySQL and PostgreSQL databases provide JSON functionality support. They introduced special data types, storing JSON data - json data type in...

Oracle 12c Support and More New Features in New Versions of Devart Products

Devart releases new versions of its products: LinqConnect ORM solution, dotConnect ADO.NET data providers, and ORM designer - Entity Developer. The main new feature...

Enhanced Entity Framework Spatials support for Oracle, MySQL and PostgreSQL

Entity Framework v5 and v6 support spatial data types. They are represented as two DbGeometry and DbGeography data types from System.Data.Entity.dll in .NET Framework...

Using Entity Framework Spatials with Oracle Spatial and SharpMap

Note The information in this article is partially outdated. For the newer information see the Enhanced Entity Framework Spatials support for Oracle, MySQL and PostgreSQL...

Using Oracle Full-Text Search in Entity Framework

Introduction Oracle database supports an advanced functionality of full-text search (FTS) called Oracle Text, which is described comprehensively in the documentation: Oracle® Text Application Developer's...

Entity Framework Code-First Migrations support for Oracle, MySQL, PostgreSQL and SQLite

ADO.NET EF providers Devart dotConnect for Oracle, dotConnect for MySQL, dotConnect for PostgreSQL, and dotConnect for SQLite implement support for Entity Framework 4.3 Beta...

Using Oracle Optimizer Hints in Entity Framework

With each new version of our Devart dotConnect for Oracle ADO.NET Entity Framework provider we pay special attention to improving its performance and configurability....

Workflow Foundation Support in dotConnect for Oracle

We continue to extend the capabilities of dotConnect for Oracle with new features. Recently we have started to implement Workflow Foundation support features in...

Set Identity and Computed Properties in Entity Framework Without Triggers

This article deals with the following: StoreGeneratedPattern Identity Computed DefaultValue InsertNullBehaviour Example Conclusion StoreGeneratedPattern Entity Framework contains an excellent functionality of server-generated columns of the entity...

Entity Framework Code-First support for Oracle, MySQL, PostgreSQL and SQLite

April 2011 saw the release of a new version of Entity Framework 4.1; this blog article and samples of code contained in it have...

Comparing Diffs Between Two Oracle Database Schemas

The article defines main requirements for a tool for Oracle schema comparison (Database Diff tool), provides brief report on different tools offering such functionality, and analyses their shortcomings and advantages.

How To Configure Oracle Instant Client

This article is a step-by-step instruction for configuring Oracle Instant Client so that our tools for Oracle could work with it. 1. Download Oracle Instant...

Social

Products