Teradata: Failure 7547 Target row updated by multiple source rows
You will get this error code when try update the target table using multiple records from source. It completely does not matter if you use MERGE or direct UPDATE statement.…
![[SOLVED] Teradata: [Error 3854] [SQLState HY000] <your object name> is not a view.](https://bigdata-etl.com/wp-content/uploads/2019/12/Untitled-1-300x180.png)
[SOLVED] Teradata: [Error 3854] [SQLState HY000] <your object name> is not a view.
In this post I will explain why you encountered an error [Error 3854] [SQLState HY000] <your object name> is not a view while executing the DDL query at Teradata, what…
SQL Server: How to check column data types in SQL Server database?
There are at least a few ways to get column data types in Microsoft SQL Server database. In this short post, I will show you two the most popular ways…
SQL Server: How to extract only year, month or day from date data type?
If you used databases like Oracle or Teradata, you can be suprised that very popular function like extract(year from date) not work for Microsoft's databases. In this post I show…
Oracle database: How can I change a user's password using Oracle SQL Developer?
We can change the password in at least two ways, using: SQL syntaxUsing Oracle SQL Developer software. Method 1 alter user user_name identified by you_new_password replace old_password; Method 2 Using…
How to install Oracle SQL Developer on Ubuntu 18.04?
In this short post I will show you how to install Oracle SQL Developer on Ubuntu 18.04. Download the latest version of Oracle SQL Developer from the official Oracle website.Select…
![[SOLVED] Teradata: [Error 3504] [SQLState HY000] Selected non-aggregate values must be part of the associated group.](https://bigdata-etl.com/wp-content/uploads/2019/12/john-schnobrich-FlPc9_VocJ4-unsplash_ENG-2-300x200.jpg)
Photo by John Schnobrich on Unsplash
[SOLVED] Teradata: [Error 3504] [SQLState HY000] Selected non-aggregate values must be part of the associated group.
In this post, I will explain why you encountered an error [Error 3504] [SQLState HY000] Selected non-aggregate values must be part of the associated group while executing the SQL query…
![[SOLVED] Why the Oracle database is slow when using the docker?](https://bigdata-etl.com/wp-content/uploads/2019/11/fernando-mate-J1R-xl_TPPM-unsplash-300x200.jpg)
Photo by Fernando Maté on Unsplash
[SOLVED] Why the Oracle database is slow when using the docker?
Recently, when I needed a testing environment, where one of the elements was the Oracle database, I encountered a problem that caused me a lot of nerves. Problem When I…
SQL Developer: How to restore / add the Connections tab in SQL Developer?
If you have been using SQL Developer for some time, you have probably encountered the situation that you accidentally or for various reasons closed the Connections tab. However, how to…
Photo by Florian Krumm on Unsplash
Teradata: How to install Teradata Express on VMware Workstation Player on Windows operating system
In this post I will show you how to install Teradata Express (VMware) version 16.20 on VMware Workstation 15.5.0 Player on the Windows operating system. A few words about technologies…
- 1
- 2
