Developing delphi+oracle

Hey !

we are new to oracle. we use delphi to connect to the oracle data base and have some questions(some, i'm sure are not very smart).

1/ is it possible to define temporary table in oracle. i.e the table

   will live only for the duration of the session and will be seen    only by the creating session.
2/ is it possible to check row level activity using the

   data base redo log. (track the before and after images of    rows for audit purposes). if not what alternatives do we    have.
3/ is it possible to display form with rows from table and

   to allow/disallow update of selected rows using one column value.    (for example, if the value of status is 9 , row is displayed but    not updateable).
4/ Can you reset sequence to zero ?
5/ can you define "dynamic" views which that are changed according

   to column values, if so how can we pass the "filter" value to the view.

Hope i'm not being rude with this "questions bombing" . any answer to one or more of the questions will be appreciated.

TIA shahar mor Received on Tue Jun 24 1997 - 00:00:00 CDT