A site about programming, IoT and technology. Find tutorials for many different projects.
The objective of this post is to explain how to lock a record on a Oracle Database, using a select statement. Introduction The objective of this post is to explain how to lock a record on a Oracle Database, using a select statement. This allows us to lock a record without the need to change …
Continue reading "Oracle SQL: Row locking on select statement"
The objective of this post is to explain how to execute queries in different transactions using SQL developer. Introduction The objective of this post is to explain how to execute queries in different transactions using SQL Developer. This way, we can execute queries simultaneously and test aspects related to concurrent transactions accessing the same tables …
Continue reading "SQL Developer: Executing queries in different transactions"
The objective of this post is to explain how to obtain the least and the greatest values across the columns of a table, in Oracle SQL. Introduction The objective of this post is to explain how to obtain the least and the greatest values across the columns of a table, in Oracle SQL. We …
Continue reading "Oracle SQL: Least and greatest values across columns"
The objective of this post is to explain how to perform the ordering of a table in Oracle SQL, using a list of values. Introduction The objective of this post is to explain how to perform the ordering of a table in Oracle SQL, using a list of values. We will start by creating a …
techtutorialsx