This article will explore the SDO_TOPO_GEOMETRY data type in Oracle 21c, including its syntax, advantages, and example usage. Introduction to Oracle SDO_TOPO_GEOMETRY Datatype Oracle 21c introduced the spatial data type SDO TOPO GEOMETRY, which is intended to facilitate topology in spatial data. SDO TOPO GEOMETRY offers a way to store and manage the relationships between … Read more >>
In this Oracle tutorial, we will learn about the Time datatype in the oracle database. Also, we will demonstrate how to use it to create time columns for a table in Oracle. Introduction to Oracle Time datatype Oracle 21c uses the TIME data type to hold time values without a date component. Similar to the TIMESTAMP data … Read more >>
In this PostgreSQL tutorial, we will discuss PostgreSQL Date Part Hour to get the hour value from the timestamp. Here we will use the function date_part() to extract the hour component with different examples such as from the current timestamp, interval, and table. What is PostgreSQL Date Part Hour The date_part() function in PostgreSQL returns … Read more >>
In this Oracle tutorial, we will learn about what is read-write mode in the Oracle database. We will also learn the procedure of how to check the read-write mode in the Oracle database. What is Read Write in Oracle Database In Oracle Database, Read Write is basically a modifier that is used to alter the … Read more >>
In this Oracle tutorial, we will check different ways to check the timezone in an Oracle database. Also, I will show you how to set the database timezone and session timezone in Oracle. How to Check Oracle Database Timezone Time zones are used because it is easy for the clients in frequent communication to keep … Read more >>
In this PostgreSQL tutorial, I will teach you how to delete row in PostgreSQL. Also, you will learn about deleting a single row or multiple rows from the table. Then at the end, I will show you how to return the deleted rows from the table and also how to delete all the rows from … Read more >>
In this PostgreSQL tutorial, I will show you how to use PostgreSQL Having clause where you will learn how to filter the aggregated result using the HAVING clause based on the given condition. Additionally, I will show how to use different aggregate functions such as count(), sum(), min(), and max() along with the HAVING clause. … Read more >>
In this PostgreSQL tutorial, you will learn how to add a foreign key if it does not exist in PostgreSQL, where you will understand why you need to add the foreign key to tables. Also, you will use the PL\PGSQL with the table pg_constraint to check whether the existing table has a foreign key or … Read more >>
In this PostgreSQL tutorial, I will demonstrate how to return table from function in PostgreSQL function. You will understand the syntax of the function, and you will also create a simple function to know how you can define your function with different parameters. How to return a table in PostgreSQL function Sometimes, you need to write … Read more >>
Do you want to know how to install SQL Server 2022 Express edition? No worries. In this SQL Server tutorial, I will show you a simple and easy way to install it on your PC. As a database developer or beginner, you must have proper knowledge about installing the SQL Server Express edition. Let’s get … Read more >>