Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sql query`

Re: sql query`

From: nullpointer <null_pointer_at_rediffmail.com>
Date: 22 Dec 2004 01:19:09 -0800
Message-ID: <1103707149.048245.252600@f14g2000cwb.googlegroups.com>


With the present structure I dont think it would be possible to get the latest address. Think about it since you are not storing the information about when a row was inserted it would be impossible for the DB to know the last inserted record.

You did not mention what is the primary key of this table. If you are lucky it might have a surrogate key populated by a sequence number ( I have seen this in some apps - they have surrogate keys even for joining tables ) In that case a possible ( though not bulletproof ) method is to select the one which has the max ( key_no ). Just check.

>From the name this looks like some sort of medical app. Most of them
have lots of auditing features - check if any auditing tables store the dates.

HTH
Dev Received on Wed Dec 22 2004 - 03:19:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US