Shivam Dogra 
If you’ve tried to query a table as a new login, you’ve probably seen “The SELECT permission was denied on the object.” SQL Server user permissions are working; nobody granted that user SELECT. The fix starts with knowing what a user can do: impersonate them with EXECUTE AS USER, run fn_my_permissions, then REVERT. You change … 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 SQL Server tutorial, we will learn everything about SQL Server Cross Join vs Left Outer Join. SQL Server is a popular relational database management system that provides several types of join operations to combine data from two or more tables. Two commonly used types of join operations in SQL Server are Cross Join … Read more >>
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 Oracle tutorial, we will learn about the urowid datatype in the oracle database. Also, we will illustrate how to use it to create urowid columns for a table in oracle. Introduction to Oracle urowid Datatype In Oracle 21c, a datatype known as a Universal Rowid (UROWID) is used to hold the actual physical address of … Read more >>
Oracle 21c is the latest version of the Oracle database management system. It introduces several new features and improvements, one of which is the Year datatype. I’ll share everything you need to know about the Oracle Year data type, including how Oracle handles year information, standard methods to work with years, and best practices. Oracle … Read more >>
In Oracle Database, there is a wide range of data types available to store different types of data. One such datatype is Interval year. A new datatype named INTERVAL YEAR was added to Oracle Database 21c and is intended to record time periods expressed in years. Applications like financial reporting and project management that require … Read more >>
In Oracle Database, there is a wide range of data types available to store different types of data. One such datatype is interval day. A new data type called “interval day” is included in Oracle 21c, the most recent version of the Oracle Database. This data type has a precision of up to microseconds and … Read more >>