Search results
06/28/2013
Article
Understanding Oracle PL/SQL
If you are a newbie, in this article we will discuss about PL/SQL, an important programing language in Oracle.
06/25/2013
Video tutorial
Views - T-SQL Step by Step Course - Lesson 20
In this video, we will talk about views. SQL Server books online define a view as follows: "A view can be thought of as either a virtual table or a stored query."
06/25/2013
Video tutorial
Subqueries - T-SQL Step by Step Course - Lesson 19
Today, we will talk about subqueries, which are queries within queries. The outermost query is a query which resultset is returned to the caller. It is known as the outer query.
06/19/2013
Video tutorial
Insert, Update and Delete - T-SQL Step by Step Course - Lesson 17
In this video, we will shift from the select statement to data modifications. After all, T-SQL gives the user the ability to change data in the tables. Sometimes, we need to update a person’s address, or remove a customer that does not exist.
06/19/2013
Article
Oracle Built in Functions
In this article we will learn about “Oracle Built in Functions” in which we learn how we can use certain types of functions like Numeric Functions, Character or Text Functions, Conversion Functions, etc in Oracle to perform operations with ease.
06/17/2013
Article
Concepts of Oracle Database
Today we are going to learn “basics of Oracle” .This is a series of Oracle tutorials in which the first part is Introduction to Oracle for beginners. This first part explains the relational theory on which database are built.
06/07/2013
Article
Basic SQL SELECT Statements
In this article, we will learn about SQL SELECT statements and how to use them to retrieve data from our database.