In this oracle tutorial, we will learn how to connect excel to oracle database. Connect Excel to Oracle Database In this section, we will learn how to connect Excel to Oracle Database without ODBC. Approach-1: Without ODBC To connect Excel to Oracle Database, follow the below steps. 1. Open Microsoft Excel and click on the … Read more >>
In this oracle tutorial, we will learn multiple approaches to connect to Oracle database using Python. How To connect To Oracle Database Using Python Read How to create a database in Oracle 19c Approach-1 Using Python Pyodbc In this section, we will learn to connect to Oracle database using Python pyodbc. Source Code: In this … Read more >>
In this Oracle tutorial, we will learn about the Long raw data in the Oracle database. Also, we will illustrate how to use it to create long raw columns for a table in Oracle. Oracle Long raw Datatype Let us start with the introduction, and then move to the other section. Introduction In Oracle, binary big … Read more >>
You must know what is happening in the database if you are a Database Administrator. You need to be aware of the activities going on in the database. Therefore, email notifications can help a lot in monitoring database activities. You can define a notification email triggered when a specific action triggers in the database. How … Read more >>
In this MongoDB tutorial, we will learn how to auto increment id in MongoDB. How to create auto increment id in MongoDB We want the _id field to be in an auto-increment sequence starting from 1, 2, 3, up to n. So consider the following documents. Unlike a relational database, MongoDB doesn’t support auto-increment features. However, we … Read more >>
In this Oracle tutorial, we will learn about the NVARCHAR2 datatype in the Oracle database and demonstrate how to use it to create NVARCHAR2 columns for a table. NVARCHAR2 in Oracle NVARCHAR2 is a Unicode data type that can store Unicode characters. When the database was created, the national character set was specified as the NVARCHAR2 character set. Variable-length … Read more >>
Azure SQL provides an option to encrypt your columns if you are storing sensitive data in the database, such as user passwords, credit card numbers, etc. You can use any encryption algorithm to encrypt the data, and only authentic users can decrypt it. How to encrypt a column in Azure SQL In this article, you … Read more >>
In this Oracle tutorial, we will learn how to create a database in Oracle 19c. How to Create a Database in Oracle 19c Let us discuss all the approaches individually. Approach-1 Using Manual Approach To create database manually in Oracle 19c, follow the below steps. Approach-2: Using DBCA Here, we will use the Graphic user … Read more >>
In this SQL Server tutorial, you will learn about MSSQL create database. The database is a collection of information that we can view, change, and delete. This tutorial explains step by step how to create a database using MSSQL. How to create a database in SQL Server 2019 To create a database in SQL Server … Read more >>
Recently, I encountered a setup wizard that ended prematurely because of an error in Windows 11 while trying to install MariaDB on my computer. I will walk you through the steps I followed to fix this error. Setup Wizard Ended Prematurely Let us illustrate two simple methods to resolve this error. First method This problem … Read more >>