Re: Find most recent rows, generically?
From: Pablo Sanchez <pablo_at_dev.null>
Date: Mon, 18 Feb 2002 13:10:08 -0700
Message-ID: <Ecdc8.1345$hb7.90231_at_news.uswest.net>
Date: Mon, 18 Feb 2002 13:10:08 -0700
Message-ID: <Ecdc8.1345$hb7.90231_at_news.uswest.net>
"DL" <donlcs_at_yahoo.com> wrote in message
news:604bb90c.0202172222.a375f10_at_posting.google.com...
> Thanks for the response, Jim, let me re-phrase my question, with MS
> SQL Server, when I add a column and define it as integer, identity,
> later I can find out if that column is of data type int etc., what's
> Oracle's equivalent of "Identity" if any? and if yes, which system
> table do I go to determine it? Thanks.
There's no 'identity' data type in Oracle. You create a 'SEQUENCE' which is used to set the corresponding data type.
-- Pablo Sanchez, High-Performance Database Engineering www.hpdbe.com Available for short-term and long-term contractsReceived on Mon Feb 18 2002 - 21:10:08 CET