Search results
10/25/2013
Video tutorial
Manipulating Data - Oracle PL SQL Course - Lesson 10
This video shows examples of how to insert the data with and without the columns names, how to update the values of columns with the UPDATE statement and how to remove some rows of the tables with the DELETE statement.
09/27/2013
Video tutorial
Subqueries - Oracle PL SQL Course - Lesson 8
The video explain the context, the details, the requirements and the usage of subqueries with aggregated functions and with the operators IN(), ANY(), and ALL().
09/25/2013
Video tutorial
Output Clause - T-SQL Step by Step Course - Lesson 37
In this video, we will discuss the output clause and the merge statement. SQL Server Books Online defines the output clause as: Returns information from, or expressions based on, each row affected by an INSERT, UPDATE, DELETE, or MERGE statement