Why don't you add a date column to the table and create a after insert
trigger to insert the sysdate into it. Then the query

select * from table where date_col > (sysdate-7) will give the rows you
want.

----- Original Message -----
From: "Jalil Zabourdine" <jalil.[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, February 28, 2002 6:16 AM
Subject: Re:Can't insert rowid!!!


Nick,
Good Question!
I was satisfied with your reply yesterday...Thanks for
that. what I am trying to achieve here is :
1/ We are updating a table once a week say 1000 rows
there will no additional rows will be inserted.
2/ I want to select two columns(customer name including
rowid) to know howmany rows have beed updated since the
previous week.
Any idea how to achive this? which is the best way to do
it?

Thanks in advance.
-Jalil

> ---------- Initial message -----------
>
> From : Nick Cowe <[Email Address Removed] To : "LazyDBA.com Discussion"
<[Email Address Removed] Cc :
> Date : Thu, 28 Feb 2002 10:11:26 -0000
> Subject : RE: can't insert rowid!!
>
> what exactly are you trying to achieve? do you want the
new row to reference
> a row in another table or are you trying to force a
rowid onto the row to
> "make" oracle store the row where you want it storing?
>
> if you want to reference another row of an already
existing row you will
> need to reference that row eg
>
> insert into table
> select rowid
> from another_table;
>
> but this shouldn't really be used in any long running
application, because
> if you reload / restore / re-import the data
in "another_table" the rowids
> will change and the rowids stored in table will be
wrong!
>
> if you are trying to make oracle store a row where you
want it storing, YOU
> CAN'T (i would be very surprised if you can, and in
which case i would be
> very scared).
>
> HTH
>
> nickc

--------------
Profitez de l'offre spéciale Tiscali Liberty Surf !
50% de temps en plus pendant 3 mois sur tous les forfaits Internet.

http://register.libertysurf.fr/subscribe_fr/signup.php3



--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page