SQL Language History, Components & Elements

Posted by admin on December 25, 2009

Definition of SQL Language:

SQL is a computer/programming language which enables a user or any application to interact with an SQL capable database management systems or DBMS. SQL is a great tool to deal with databases. It is used to access and manipulate databases & It is very easy to implement.

In this tutorial, we will explain about the basics of SQL language, its history and its implementations.

SQL stands for Structured Query Language.

It is an ANSI (American National Standards Institute) standard language used for accessing and manipulating databases.

There are different databases, such as, MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database systems. We will basically deal with Oracle. WAIT! There is more to read… read on »

SQL Sequences

Posted by admin on December 23, 2009

SQL Sequences Introduction:

The use of sequence is very important in Oracle. A sequence is a database item that generates a sequence of integers. It is a set of integers that are used to create a unique number to act as a primary key.

Sytax of an Oracle Sequence

The syntax for a sequence is:

CREATE SEQUENCE sequence_name
MINVALUE value
MAXVALUE value
START WITH value
INCREMENT BY value
CACHE value;

SQL Sequence Example: WAIT! There is more to read… read on »