Oracle 12 IDENTITY Columns
Hello everyone, today we wanted to discuss with you a feature of Oracle 12.1 that is very powerful and rarely used, the IDENTITY columns. This functionality is implemented in most …
Hello everyone, today we wanted to discuss with you a feature of Oracle 12.1 that is very powerful and rarely used, the IDENTITY columns. This functionality is implemented in most …
Hello everyone. Today we are going to talk about the installation and configuration of OCI CLI on Linux. This OCI tool will be useful to have installed if you are …
Hello everyone, today we are going to talk to you about several ways to get recovery mode in SQL Server . Each recovery mode has its pros and cons. That …
Hello everyone, today we are going to talk about a simple trick that can be useful in various situations. It is about simulating a backup in SQL Server . We …
Hello everyone, today we are going to talk about how to import records from SQL Server to RStudio. For this, we will make use of the RODBC package. As its …
In today’s example we are going to see how to solve the following error using Count Distinct and Window Functions. It is an error that we have had with some …