Category Archives: SQL

Oracle SQL: Row locking on select statement

The objective of this post is to explain how to lock a record on a Oracle Database, using a select statement. Advertisements

Posted in SQL | Tagged , , , , , , | Leave a comment

SQL Developer: Executing queries in different transactions

The objective of this post is to explain how to execute queries in different transactions using SQL developer.

Posted in SQL | Tagged , , , , , | 1 Comment

Oracle SQL: Least and greatest values across columns

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.

Posted in SQL | Tagged , , , , , , , | Leave a comment

Oracle SQL: Order by list of values

The objective of this post is to explain how to perform the ordering of a table in Oracle SQL, using a list of values.

Posted in SQL | Tagged , , , , , , , | Leave a comment

Pythonanywhere: Accessing the MySQL database

The objective of this post is to explain how to access the MySQL database of a free Pythonanywhere account and perform some simple tests.

Posted in SQL | Tagged , , , , , , , | Leave a comment