Sequences to gen PKs.

From: Mark Framness <framnesso_at_my-deja.com>
Date: Mon, 20 Dec 1999 18:14:03 GMT
Message-ID: <83lrl7$8m0$1@nnrp1.deja.com>

Hey All!

I am studying for the SQL-PL/SQL OCP exam.

I have a question regarding the use of sequences to generate primary keys.

On page 162 of the OCP Application Developer Guide it addresses the use of sequences to generate primary keys:
"This task is common in situations where the primary key is not important to use for accessing data to store in a table."

What are they talking about? I get the second part about the inherit crypticness of a sequence number as a PK but the first point has me boggled.

Thanks

--
From: Mark Framness
http://netnet.net/~farmer/index.html
All standard disclaimers apply anyone who say otherwise is itching for a

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 20 1999 - 12:14:03 CST