Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sequence in Teradata

Status
Not open for further replies.

ChandruN

Programmer
Jun 17, 2003
13
US


do we have sequence concept in teradata.

In oracle, we can generate serial no using sequences.

I would appreciate your help .


 
Starting with V2R5 there's a sequence, check the SQL DDL manual:

Chapter 1: SQL Data Definition Language Statement Syntax
CREATE TABLE (Column Definition Clause)
Identity Columns

Dieter
 
Hi,
Identity column does not guarentee a sequence. It just guarentees some UNIQUE value will be added to the row when it is inserted automatically.

In a relational database there is no concept of the rows ordered on Disk. Order can only be applied when they are selected out and for that you can use the CSUM or RANK function based upon fileds in the row ( like a timestamp embeded in the row by your application )
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top