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 LazyDBA home page