How to create table in Oracle

create oracle table using sql developer tool - create table

In this Oracle tutorial, we will learn about how to create table in oracle database 19c. Also, we will cover these topics. Note: Ideally we should create a table on the Pluggable database (PDBs) But to keep things simple we have demonstrated it on a common user (c##). Oracle Create Table In this section, you … Read more >>

Oracle Database vs MySQL Database

Oracle Database vs MySQL Database

In this Oracle tutorial, we will strike the difference between oracle database vs MySQL database. Also, we will cover these topics. Oracle Database vs MySQL vs SQL Server In this section, we will see the difference between oracle vs MySQL vs SQL Server. All three are popular databases and serve most of the organizations that … Read more >>

Number Datatype in Oracle Database

precision in oracle database

In this Oracle tutorial, we will learn about the number datatype in oracle database. Also, we will cover these topics apart from the oracle numeric data type. Number Datatype in Oracle Size In this section, we will learn about the size of Number data type in oracle database. Read How to create a database in … Read more >>

Connect to Oracle Database using Python

Connect to Oracle Database using Python Pyodbc

In this oracle tutorial, we will learn how to connect to an oracle database using python. Also, we will cover these topics. Connect to Oracle Database using Python In this section, we will learn how to connect to oracle database using pyython. Read How to create a database in Oracle 19c Connect to Oracle Database … Read more >>

How to create a database in Oracle 19c

How to create a database in Oracle 19c

In this oracle tutorial, we will learn how to create a database in Oracle 19c. Also, we will cover these topics. How to Create a Database in Oracle 19c In this section, we will learn how to create a database in oracle 19c step by step manually oracle 19c. Create a Database in Oracle 19c … Read more >>

How to Fetch Data from Oracle Database in Python

How to Fetch Data from Oracle Database in Python

In this tutorial, we will learn how to fetch data from the oracle database in python. Also, we will cover these topics. Pre Requisites – Database details In this tutorial, we are going to use a table gift_store that has 6 columns with different data types. Here is the data that we inserted in the … Read more >>

Connect Excel to Oracle Database

Connect Excel to Oracle Database

In this oracle tutorial, we will learn how to connect excel to an oracle database. also, we will cover these topics. Connect Excel to Oracle Database In this section, we will learn how to connect Excel to Oracle Database without ODBC. Read How to Check Oracle Database Version Connect Excel to Oracle Database with ODBC … Read more >>

How to Check Oracle Database Version

How to Check Oracle Database Version in SQL Developer

In this Oracle tutorial, we will learn how to check oracle database version. Also, we will cover these topics. How to Check Oracle Database Version in Linux In this section, we will learn how to check the oracle database version in Linux using the command line or Terminal. Using the below command on a terminal … Read more >>

How to Get List all Tables in Oracle Database

Get list of all tables in Oracle

In this Oracle tutorial, we will learn how to write a query to list all tables in oracle database. Also, we will cover these topics. Query to List all Tables in Oracle Database In this section, we will learn how to write a query to list all tables in oracle database. This is how to … Read more >>

Oracle 19c installation on Windows 10 + Video Tutorial

Oracle 19c installation on windows 10

In this Oracle tutorial, we will see a complete step-by-step on Oracle 19c installation on Windows 10. Also, we will see, how to install oracle database 21c on windows 10. Also, we will cover these topics. Brief History of Oracle database & its versions Oracle database is a powerful and safe relational database software created … Read more >>