Re: Find most recent rows, generically?

Thanks anyway, but you missed my question, I don't have problem getting data types for columns of a table, I was wondering if or what is the equivalent of "identity"(MS SQL Server) from Oracle.

DL  

mngong_at_yahoo.com (michael ngong) wrote in message news:<ecf365d5.0202180431.1768bf6f_at_posting.google.com>...
> donlcs_at_yahoo.com (DL) 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.
> >
> > DL
> >
> > "Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:<9qhb8.431$Ot2.153407_at_sccrnsc01>...
> > > You can't. If it is important to know if it was recent then you need a
> > > column to model that attribute.
> > > Jim
> > > "DL" <donlcs_at_yahoo.com> wrote in message
> > > news:604bb90c.0202150930.49ef0fc5_at_posting.google.com...
> > > > Hi,
> > > >
> > > > First of all, I thank those who have been very helpful in the past.
> > > > How to find most recent rows, say, 10, (for insert and update
> > > > transactions), generically?
> > > >
> > > > For insert:
> > > > Well, one can find PK column of a given table, suppose, single column,
> > > > then determine data type of that column, if it is of integer or
> > > > similar type data,
> > > > 1(a) how would one know that it uses "identity" attribute for it
> > > > (thus, incremental)?
> > > > 1(b) and if it does not, how to proceed?
> > > > 2, what if it is of random alphnumeric?
> > > > 3, what if it is of composite keys?
> > > >
> > > > For update:
> > > > ???
> > > >
> > > > * Question category 1 is most important to me for now.
> > > >
> > > > Thanks.
> > > >
> > > > DL
> The one way that I use to find out the datatype is to describe the table
> and it will list all the variables and their datatypes
> Michael Ngong( Sr DBA)
Received on Mon Feb 18 2002 - 22:31:30 CET